Comments by NANDKUMAR GAIKWAD (Top 14 by date)

i done it i'll send you what i done

yes i debug and getting only output
"CREATE TABLE Table
)"
this is an outpu
can i send you full code with aspx
that you can debug you side
i cant find out exact problem

i use your code as follow

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
//Label2.Text = "Table Name : " + Convert.ToString(ListBox1.SelectedItem.Text);
Label2.Text = "table name: " + Convert.ToString(DropDownList1.SelectedItem.Text);
//DataSet objds = fetchTallyTableContent(Convert.ToString(ListBox1.SelectedItem.Text));
DataSet objds = fetchTallyTableContent(Convert.ToString(DropDownList1.SelectedItem.Text));
GridView2.DataSource = objds;
GridView2.DataBind();
// Call the method
//DataTable yourDataTableObj = new DataTable();
//string sqlQuery = CreateTABLE(yourDataTableObj);
DataTable dt = new DataTable(Convert.ToString(DropDownList1.SelectedItem.Text));
string sqlQuery = CreateTABLE(dt);
textbox1.Text = sqlQuery;
}

public DataSet fetchTallyTableContent(string tblName)
{
//string query = "SELECT * FROM Techweb.TallyUser." + tblName + " " + tblName;
string query = "SELECT * FROM DatavisionITC.TallyUser." + tblName + " " + tblName;
string source = "PORT=9000;DRIVER=Tally ODBC Driver;SERVER={(local)}";
OdbcConnection con = new OdbcConnection(source);
OdbcCommand cmd = new OdbcCommand(query, con);
con.Open();
OdbcDataAdapter da = new OdbcDataAdapter(query, con);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
return ds;
}
public static string CreateTABLE(DataTable table)
{
string sqlQuery;
sqlQuery = "CREATE TABLE " + table.TableName + "(";
for (int i = 0; i < table.Columns.Count; i++)
{
sqlQuery += "\n [" + table.Columns[i].ColumnName + "] ";
string columnType = table.Columns[i].DataType.ToString();

// You will get different data type in C#(you need to change it SQLServer):Boolean,Byte,Char,DateTime,Decimal,Double,Int16,Int32,Int64,SByte,Single, String,TimeSpan,UInt16,UInt32,UInt64
switch (columnType)
{
case "System.Int32":
sqlQuery += " int ";
break;
case "System.Int64":
sqlQuery += " bigint ";
break;
case "System.Int16":
sqlQuery += " tinyint ";
break;
case "System.Decimal":
sqlQuery += " decimal ";
break;
case "System.DateTime":
sqlQuery += " datetime ";
break;
case "System.String":
default:
sqlQuery += string.Format(" nvarchar({0}) ", table.Columns[i].MaxLength == -1 ? "max" : table.Columns[i].MaxLength.ToString());
break;
}

if (table.Columns[i].AutoIncrement)
sqlQuery += " IDENTITY(" + table.Columns[i].AutoIncrementSeed.ToString() + "," + table.Columns[i].AutoIncrementStep.ToString() + ") ";

if (!table.Columns[i].AllowDBNull)
sqlQuery += " NOT NULL ";
sqlQuery += ",";
}

return sqlQuery.Substring(0, sqlQuery.Length - 1) + "\n)";
}
}

i get table name but now problem is that output look like this
where i exactly mistaking i cant find out
"CREATE TABLE State
)"
this is an output

yes i'm getting proper schema from i tried code..
but when i trying for single table or multiple table it not generate script

there is no problem with binding i'm trying i get schema from my below code

string source = "PORT=9000;DRIVER=Tally ODBC Driver;SERVER={(local)}";
OdbcConnection con = new OdbcConnection(source);
con.Open();
DataTable dt = new DataTable();
string[] restrictions = new string[1];
dt = con.GetSchema("Tables");
Database db = new Database();

DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "Table_Name";
DropDownList1.DataValueField = "Table_Name";
DropDownList1.DataBind();

i want how to generate table in sql server 2008 with this schema of table and there column name and there data type
but when i use your code i get that schema's datatable information

thanx for suggestion.
and i'm new to here..but this is not excuse..
your answer is fabulous..
i send post my code and tell me what is wrong with that

thanx but i'm new on code project i dont know where to comment and where to accept solution i'm trying my self...kindly adjust..thanx in advance