Hi there,

Probably this will look like a silly question to all you masters in asp.net but i am beginner and needs help. I know how we can write queries in connected model but my question is how can we do these similar opertions(insert, delete, update) in disconnected model????


Please help...

In Disconnected mode there is DataAdapter in between your application and database.
Dataapater retrieves all data from database like.

da=new DataAdapter("Select * from SampleTable",cn);
da.fill(dt);

There are fill and update methods of DataAdapter for these operation.
once you got the data in datatable then you can eaisily do the update ,Delete ,and Add operation on DataTable.

and , Finally using update method just the database.

da.Update(dt);

Hope , this helps you.

for update

dim cmd as new sqlcommand
dim con as new sqlconnection
con=Newsqlconnecton(configurationmanager.connectionstring("connectionstringname").connectionstring)
con.open()
cmd.connection=con
cmd.comandtext="update tablename set pass=@pass where empcode=@empcode"
cmd.parameter.add("@pass",sqldbtype,varchar,50).value=txtpass.text
cmd.parameters.add("@Empcode",sqldbtype,varchar,50).value=session("empcode")
cmd.execute nonquery()