suresh bangaru

sqlcmd = New SqlCommand("INSERT INTO tablename (field1,field2,field3,..)values('" & textbox1.text & "','" & textbox2.text & "','" & textbox3.text & "',...),con) cmd.ExecuteNonQuery()

to change session timeout write this code in your web.config file <sessionState mode="InProc" timeout="60"> or you can also set this in global.asax file as Session.Timeout = 60 ; // in Session.Start() event it will increase your session expire time .

hi, I want to display data in to form(form contains textbox,combobox,datagrid) from database.

try con.Open() insertcommand = new OleDb.OleDbCommand ("INSERT INTO Reservations (Transaction_Id, Item_Id, User_Id,Current_Date, Reserved_Until, Contact_Name, Contact_Tel)VALUES (trim(txtTransactionId.text), trim(txtItemId.text),trim(userid.text),dtpicker1.value.ToShortDateString, dtpicker2.value.ToShortDateString, trim(txtContactName.text),trim(txtContactTelp.text))",con) cmd.ExecuteNonQuery() msgbox("data Inserted") con.close() Catch ex As Exception MsgBox(ex.Message) End Try