Without behind code how to bind data to gridview ?

Question

please tell me without behind code(i.e. no events firing) .if i am click on save button.Data will save on Database and visible to Gridview.

Narayana · Answer

Hi Ramesh  without behind cod(ie .aspx.cs) .

Ramesh Palanivel · Answer

Hi Narayana Try this code public void DisplayRecords() { con.open(); //your sql connection Dataset ds= new Dataset(); SqlDataAdapter sdr= new SqlDataAdapter( select * from tableName con); sdr.Fill(ds); datagridview1.Datasource=ds.Tables[0]; con.close(); } public button1_click(Event esender obj) { con.open(); sqlcommand insert= new sqlcommand( insert tablename(fieldsdetails)values(textboxvalues) con); insert.ExcuteNonQuery(); con.close(); DisplayRecords(); //Call the datagridview to update the inserted records. }

Without behind code, how to bind data to gridview ?