how to Dynamically create GridView or HTMl table frm dataset

Hi Everyone,
I have to generate a WebApplication in which I need to excecute sql files which contains multiple select staments.
I have created Application and I am able to retrieve multiple table in dataset.
But not able to create gridview dynamically..

My code is like this

code under pageload
SqlCommand cmd;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString);
Boolean fileOK = false;
if (FileUpload1.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
String[] allowedExtensions = { ".sql", ".txt" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
string path = FileUpload1.PostedFile.FileName;
System.IO.StreamReader sr = new System.IO.StreamReader(path);

string line;
StringBuilder sb = new StringBuilder();
int counter = 0;
while ((line = sr.ReadLine()) != null)
{
sb.AppendLine(line);
counter++;
}
string command = sb.ToString();
cmd = new SqlCommand(command, conn);

DataSet ds = new DataSet();
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
}

catch (Exception ex)
{

}

finally
{

conn.Close();

}

}

else
{
Response.Write("Please select a sql or text file");
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dipankar Biswas11y ago
Hi

Check this link...http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/
Nanhe Siddique11y ago
you can bind gridview with dataset (gridview that already declare on your page at design time)
```
 if (ds.Tables[0].Rows.Count != 0)         {
```
GridView1.DataSource = ds
```
GridView1.DataBind();

}
```