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