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;"); > >> >> >>> > >> >> >> > >> >> >> > >> >> > > >> >> > >> > > >> > > >
