Hi, I have an excel files "c:\test.xls I want to modify excel tables with asp.net . I am using this codes but it is not run correctly. How can i solve this problem? Thanks. Dim sConn As String Dim OleConn As OleDbConnection Dim OleCmd As OleDbCommand sConn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.xls;Extended Properties=""Excel 8.0;HDR=No;""" OleConn = New OleDbConnection(strConn) OleConn.Open() OleCmd = OleConn.CreateCommand() Olecmd.commandtext="UPDATE [sheet1$F1:A1] SET F1 ='6'" OleCmd.ExecuteNonQuery() OleCmd = Nothing OleConn.Close()

first you must select a database and tables from enterprise manager which you want to insert excel table into. then click the right button of the mouse and select import data. The menu steps show you how to solve this problem.

Hi, I designed a menu with macromedia dreamweaver.It created a javascript and a file like *.js by it self. I wanted to use this menu in my asp.net project therefore i copied the html codes and files from macromedia and pasted into my project. When i run my asp.net project i can see the menu but the menu is not working properly. It's colors must change when the mouse is on but not work. How can i use macromedia projects in asp.net. I want to include the macromedia codes in my project like this: "" how can i do it? Thanks.

i have code like this : Dim SQL As String SQL = String.Format("delete from CEVAPLAR where PERSONEL_ID={0} and BOLUM_ID={1} and DONEM='{2}'", ddlPersonel.SelectedItem.Value, ddlBolumAdi.SelectedItem.Value, Session("donem")) Dim cmd As New SqlCommand(SQL, cn) cmd.Connection.Open() Dim sql1 As String sql1 = String.Format("delete from NOTLAR where PERSONEL_ID={0} and BOLUM_ID={1} and DONEM='{2}'", ddlPersonel.SelectedItem.Value, ddlBolumAdi.SelectedItem.Value, Session("donem")) Dim cmd1 As New SqlCommand(sql1, cn) cmd1.Connection.Open() there is two sql command here. I want to run this querries in a transaction.if one of them this querries are cancelled both of them are made rollback. How can i coded this transaction in asp.net vb codebehind.? Thanks..

I want to explain something about what i want to do. I am making a test-quiz projects for students.There is a lot of questions and choices in the database.I want to relate with questions to labels and choices to radiobuttonlists items. label1.text =question1 radiobuttonlist1.item(0).text=choice1 radiobuttonlist1.item(1).text=choice2 radiobuttonlist1.item(2).text=choice3 radiobuttonlist1.item(3).text=choice4 label2.text=question2 radiobuttonlist2.item(0).text=choice5 radiobuttonlist2.item(1).text=choice6 radiobuttonlist2.item(2).text=choice7 radiobuttonlist2.item(3).text=choice8 . . . I want to do this in a loop and i have to use (i think) label(i).text, radiobuttonlist(i).items(0).text vs. How can i do this?