hi himanshu u can receive coding from google search topic InsertDataUsingSqlCommandBuilder or DeleteDataUsingSqlCommandBuilder or UpdateDataUsingSqlCommandBuilder
On Sat, Aug 22, 2009 at 9:44 PM, himanshu kaushik < [email protected]> wrote: > ranveer mere bhai u r ryt.pr maine ye sab kiya hai where is ur builder > object in ds.update(ds) > i m agree with u that we use adapter but not builder for all these > operations > thik hai mere bade bhai main apki bat manta hu > ok pr eske bina main ye sb kam kar raha hu mujhe working coding do main > run karke dekhunga fir main apko reply karunga > take care.i hope u can understand hindi > > > > On 8/21/09, Ranveer Singh <[email protected]> wrote: >> >> >> no himanshu i m not wrong when we insert, update ordalete in >> disconnected environment >> we use method >> da.update(ds); >> or >> da.update(ds,"tablename"); >> we required to buid the command >> u can try i u can then i m wrong >> >> Ranveer >> >> >> >> >> >> >> >> >> On 8/21/09, himanshu kaushik <[email protected]> wrote: >> > no ranveer u r wrong i used many times dataadpter without cammand >> > builder.all work perfectly.jst remove command builder from u coding it >> will >> > work >> > >> > i can mail u coding of it. >> > >> > >> > On 8/20/09, Ranveer Singh <[email protected]> wrote: >> >> >> >> >> >> hi himanshu when we passing a command through SqlDataAdapter we >> >> required to build the command like SqlCommandBuilder sb=new >> >> SqlCommandBuilder(da); >> >> da is object of SqlDataAdapter >> >> >> >> On 8/19/09, himanshu kaushik <[email protected]> wrote: >> >> > ranveer where u r using sqlcoommand builder using.u jst created >> instance >> >> of >> >> > it >> >> > i think u want to say that >> >> > SqlDataAdapter da= new SqlDataAdapter(select * from table1",conn); >> >> > DataSet ds = new DataSet(); >> >> > da.Fill(ds, "table1"); >> >> > dataGridView1.DataSource = ds; >> >> > dataGridView1.Databind(); >> >> > >> >> > coding for displaying gridview in page i think >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > On 8/18/09, Ranveer Singh <[email protected]> wrote: >> >> >> >> >> >> >> >> >> you can use this code create a table in sql table1 in your project >> >> >> database >> >> >> darg & drop datagridview1 in your form >> >> >> >> >> >> private void button1_Click(object sender, EventArgs e) >> >> >> { >> >> >> SqlConnection conn = new SqlConnection("data souurce = .; >> >> >> database=project;integrated security=true"); >> >> >> con.open(); >> >> >> SqlDataAdapter da= new SqlDataAdapter(select * from table1",conn); >> >> >> SqlCommandBuilder sb = new SqlCommandBuilder(da); >> >> >> DataSet ds = new DataSet(); >> >> >> da.Fill(ds, "table1"); >> >> >> dataGridView1.DataSource = ds; >> >> >> dataGridView1.DataMember = ds.Tables[0].ToString(); >> >> >> } >> >> >> >> >> >> >> >> >> >> >> >> thanks >> >> >> Ranveer >> >> >> Mob:9999053836 >> >> >> >> >> >> >> >> >> On 8/18/09, bala murugan <[email protected]> wrote: >> >> >> > Yashika, >> >> >> > >> >> >> > Have this >> >> >> > Password=password;Persist Security Info=True;User ID=sa;Initial >> >> >> > Catalog=SharePoint_Config;Data Source=bala\sqlexpress >> >> >> > >> >> >> > >> >> >> > Thanks, >> >> >> > Bala. >> >> >> > Mob:9003015803 >> >> >> > http://balaweblog.wordpress.com >> >> >> > >> >> >> > >> >> >> > >> >> >> > On Mon, Aug 17, 2009 at 6:18 PM, Yashika <[email protected]> >> wrote: >> >> >> > >> >> >> >> SqlConnection conn = new SqlConnection("Data Source='MOI-PC/ >> >> >> >> SQLEXPRESS';Initial Catalog =project;User >> >> >> >> >> >> >> >> ID=sa;Password=madurai;"); >> >> >> >> >> >> >> >> >> >> >> >> On 8/16/09, stanlei <[email protected]> wrote: >> >> >> >>> >> >> >> >>> >> >> >> >>> is there anything wrong with this ... >> >> >> >>> SqlConnection conn = new SqlConnection("Data Source='MOI-PC/ >> >> >> >>> SQLEXPRESS';Initial Catalog =project;Integrated >> Security=SSPI;User >> >> >> >>> ID=sa;Password=madurai;"); >> >> >> >>> >> >> >> >> >> >> >> >> >> >> >> > >> >> >> >> >> > >> >> >> > >> > >
