sorry if i'm posting in the wrong forums(but this seems to be the closest one to my qn)
ok...to makes things short...how do i create a table using sql commands in the backend code when say i click a button ..please help..
Windows Forms Data Controls and Databinding
Wrote this for a similar question in another post. Builds the table and fills it.
Dim data As New DataTable
Dim conn As New SqlConnection("Data Source=Server;Initial Catalog=Northwind;Integrated Security=True")
Dim sqlSelectCmnd As New SqlCommand("SELECT * FROM Categories", conn)
Dim sqlReadr As SqlDataReader = sqlSelectCmnd.ExecuteReader(CommandBehavior.KeyInfo)
Dim schema As DataTable = sqlReadr.GetSchemaTable()
For Each row As DataRow In schema.Rows
Dim column As New DataColumn(row("BaseColumnName"), row("DataType"))
There is very little difference, I haven't ran the code below but it looks ok.
DataTable data = New DataTable();
SqlConnection conn = New SqlConnection("");
SqlCommand sqlSelectCmnd = New SqlCommand("SELECT * FROM Categories", conn);
SqlDataReader sqlReadr = sqlSelectCmnd.ExecuteReader(CommandBehavior.KeyInfo);
DataTable schema = sqlReadr.GetSchemaTable();
foreach (DataRow row in schema.Rows)
DataColumn column = new DataColumn(row("BaseColumnName"), row("DataType"));
This is a lot easier, use a DataSet and DataAdapter:
SqlDataAdapter da = new SqlDataAdapter("select * from personnel", "MyConnectionString" );
DataSet ds = new DataSet();
err...sorry guys..i think i didn't make myself clear...the table i want to create is a database table...
tempcreateCommand.CommandText ="create TEMPORARY TABLE userpw ( `Password` text)";
something like that...
Sorry about the misunderstanding. Sure you can create a database table:
SqlCommand sc = new SqlCommand("create table xyz (MyField varchar(5))", new SqlConnection(("MyConnectionString" ));
But, my question to you is: What exactly do you want to accomplish I notice you used TEMPORARY TABLE in your example. I don't think you'll be able to create a temporary table ... in SQL, that's accomplished by CREATE TABLE #xyz ... at least it didn't work when I tried it. Do you NEED a temporary table You could just create a normal table and then drop it when you're done with. But, again, I guess I'm just wondering what you're trying to do, because there's usually several ways to solve a problem.