How to create a dynamic grid view by getting values from sql db using c#

Posted by Ak_netchat under ASP.NET on 1/11/2011 | Points: 10 | Views : 4731 | Status : [Member] | Replies : 2
How to create a dynamic grid view by getting values from sql db using c#




Responses

Posted by: Madhuk on: 1/11/2011 [Member] Starter | Points: 25

Up
0
Down
check the link how to save and retrieve data.
http://www.aspsnippets.com/Articles/Save-and-Retrieve-Dynamic-TextBox-values-in-GridView-to-SQL-Server-Database.aspx

Ak_netchat, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 1/11/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
try this code


public partial class _Default : System.Web.UI.Page

{
#region constants
const string NAME = NAME ;
const string ID = ID ;
#endregion

protected void Page_Load(object sender EventArgs e)
{
loadDynamicGrid();
}

private void loadDynamicGrid()
{
#region Code for preparing the DataTable

//Create an instance of DataTable
DataTable dt = new DataTable();

//Create an ID column for adding to the Datatable
DataColumn dcol = new DataColumn(ID typeof(System.Int32));
dcol.AutoIncrement = true;
dt.Columns.Add(dcol);

//Create an ID column for adding to the Datatable
dcol = new DataColumn(NAME typeof(System.String));
dt.Columns.Add(dcol);

//Now add data for dynamic columns
//As the first column is auto-increment we do not have to add any thing.
//Let's add some data to the second column.
for (int nIndex = 0; nIndex < 10; nIndex++)
{
//Create a new row
DataRow drow = dt.NewRow();

//Initialize the row data.
drow[NAME] = Row- + Convert.ToString((nIndex + 1));

//Add the row to the datatable.
dt.Rows.Add(drow);
}
#endregion

//Iterate through the columns of the datatable to set the data bound field dynamically.
foreach (DataColumn col in dt.Columns)
{
//Declare the bound field and allocate memory for the bound field.
BoundField bfield = new BoundField();

//Initalize the DataField value.
bfield.DataField = col.ColumnName;

//Initialize the HeaderText field value.
bfield.HeaderText = col.ColumnName;

//Add the newly created bound field to the GridView.
GrdDynamic.Columns.Add(bfield);
}

//Initialize the DataSource
GrdDynamic.DataSource = dt;

//Bind the datatable with the GridView.
GrdDynamic.DataBind();
}
}



Thanks
Karthik
www.f5Debug.net

Ak_netchat, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response