Datatables
-
yes alredy no table exist i nnorthwind with this name. but with this command i m creating new table n also create columns n rows and add data in it. DataTable dt = new DataTable("tblcheck"); DataColumn dc1=new DataColumn("col1",typeof(int)); dt.Columns.Add(dc1); DataColumn dc2=new DataColumn("col2",typeof(int)); dt.Columns.Add(dc2); DataRow dr1 = dt.NewRow(); dr1["col1"]=1; dr1["col2"]=2; dt.Rows.Add(dr1); SqlDataAdapter adp2 = new SqlDataAdapter("select * from tblcheck", con); adp2.Fill(ds, "tblcheck"); GridView1.DataSource = ds; GridView1.DataBind();
Chohan
chohanpk wrote:
SqlDataAdapter adp2 = new SqlDataAdapter("select * from tblcheck", con); adp2.Fill(ds, "tblcheck"); GridView1.DataSource = ds; GridView1.DataBind();
This is looking for a table in your database, creating one in local memory, with nothing in it, is not going to do anything. Even if you were examining the table you created ( in memory, not in you DB ), it would still be empty. What are you hoping to achieve here ?
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
chohanpk wrote:
SqlDataAdapter adp2 = new SqlDataAdapter("select * from tblcheck", con); adp2.Fill(ds, "tblcheck"); GridView1.DataSource = ds; GridView1.DataBind();
This is looking for a table in your database, creating one in local memory, with nothing in it, is not going to do anything. Even if you were examining the table you created ( in memory, not in you DB ), it would still be empty. What are you hoping to achieve here ?
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
here is code: DataTable dt = new DataTable("tblcheck"); DataColumn dc1 = new DataColumn("col1", typeof(int)); dt.Columns.Add(dc1); DataColumn dc2 = new DataColumn("col2", typeof(int)); dt.Columns.Add(dc2); DataSet ds = new DataSet(); ds.Tables.Add(dt); DataRow dr1 = dt.NewRow(); dr1["col1"] = 1; dr1["col2"] = 2; dt.Rows.Add(dr1); //SqlDataAdapter adp2 = new SqlDataAdapter("select col1 from dt", con); //adp2.Fill(ds, "dt"); GridView1.DataSource = ds; GridView1.DataBind(); if i dont nclude these rows, "SqlDataAdapter adp2 = new SqlDataAdapter("select col1 from dt", con); adp2.Fill(ds, "dt");" then it shows values. but with these dataadapter code it gives error.i want to use dataadpater to fill the dataset.what will be the solution?
Chohan
-
here is code: DataTable dt = new DataTable("tblcheck"); DataColumn dc1 = new DataColumn("col1", typeof(int)); dt.Columns.Add(dc1); DataColumn dc2 = new DataColumn("col2", typeof(int)); dt.Columns.Add(dc2); DataSet ds = new DataSet(); ds.Tables.Add(dt); DataRow dr1 = dt.NewRow(); dr1["col1"] = 1; dr1["col2"] = 2; dt.Rows.Add(dr1); //SqlDataAdapter adp2 = new SqlDataAdapter("select col1 from dt", con); //adp2.Fill(ds, "dt"); GridView1.DataSource = ds; GridView1.DataBind(); if i dont nclude these rows, "SqlDataAdapter adp2 = new SqlDataAdapter("select col1 from dt", con); adp2.Fill(ds, "dt");" then it shows values. but with these dataadapter code it gives error.i want to use dataadpater to fill the dataset.what will be the solution?
Chohan
chohanpk wrote:
.i want to use dataadpater to fill the dataset
OK, then you need to point the dataadapter to a table that exists
chohanpk wrote:
select col1 from dt
OK, that plain won't work. In your SQL, you're pointing to objects in your database, not local variables.
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
chohanpk wrote:
.i want to use dataadpater to fill the dataset
OK, then you need to point the dataadapter to a table that exists
chohanpk wrote:
select col1 from dt
OK, that plain won't work. In your SQL, you're pointing to objects in your database, not local variables.
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
What you're trying to do, makes no sense. What do you want to achieve ? Are you hoping to create a table in the DB ? Are you hoping to create a local table and use SQL on it ? You can specify a dataview, which operates SQL on a datatable, at least, I think you can. why don't you just create a table in your database ?
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
What you're trying to do, makes no sense. What do you want to achieve ? Are you hoping to create a table in the DB ? Are you hoping to create a local table and use SQL on it ? You can specify a dataview, which operates SQL on a datatable, at least, I think you can. why don't you just create a table in your database ?
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
i ve to do it with dataview.but i want to know how i can add it to db n then display through dataadapter.
Chohan
Well, wait a minute. You don't want to write code that adds tables at random, do you ? you need to write the SQL to create the table, and execute it, through a connection, probably calling ExecuteNonQuery, as you want nothing back. Then you need to run some inserts, if you want some data to select from.
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
Well, wait a minute. You don't want to write code that adds tables at random, do you ? you need to write the SQL to create the table, and execute it, through a connection, probably calling ExecuteNonQuery, as you want nothing back. Then you need to run some inserts, if you want some data to select from.
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
yeah.i want to add tables,insert columns ,rows and then display data of that tables.
Chohan
Why would you want to write a program that keeps adding tables to your database ? What for ?
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
Why would you want to write a program that keeps adding tables to your database ? What for ?
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
-
OK, what you've hopefully learned is, create your tables in SQL, then query them using SQL in your C# code.
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert