GridView in ASP.NET

Question

i am using DataGrid control. i bind it with the ADO.NET.

i want if any new data comes it should append it with the old data column wise in grid view. how this can be done?

DataTable dt = new DataTable();
SqlConnection con = new SqlConnection();
con.ConnectionString = "server = (local); initial Catalog = SQLTraining; Integrated Security = SSPI";
con.Open();
string Selectstring = "select "+attribute_name+" from "+tablename+"";
SqlCommand cmd = new SqlCommand(Selectstring, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);

gd.DataSource = dt;
gd.DataBind();

codeandcloud · Accepted Answer · 2011-05-18 16:29:18Z

1

Try to use DataTable.Merge():

DataTable newData = GetDataFromDatabase(); // your code there
DataTable oldData = (DataTable)gd.DataSource;
gd.DataSource = oldData.Merge(newData);
gd.DataBind();

Anyway, consider to use using(){} block:

DataTable dataTable = new DataTable();
string connectionString = "server = (local); initial Catalog = SQLTraining; Integrated Security = SSPI";
string selectCommandText = String.Format("SELECT {0} FROM {1}",
    attribute_name,
    tablename);
using (SqlConnection selectConnection = new SqlConnection(connectionString))
{
    using (SqlDataAdapter adapter = new SqlDataAdapter(selectCommandText, selectConnection))
    {
        adapter.Fill(dataTable);
    }
}
gridView.DataSource = dataTable;
gridView.DataBind();

edited May 18, 2011 at 16:29

codeandcloud

55.5k47 gold badges169 silver badges259 bronze badges

answered May 18, 2011 at 11:47

abatishchev

101k88 gold badges303 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

abatishchev Over a year ago

@naveen: to make it even more correct, it's better to use parameterized queries. can you add that please?:)

FIre Panda · Accepted Answer · 2011-05-18 11:49:06Z

0

You could use DataTable.Merge method. Have a look at MSDN.

answered May 18, 2011 at 11:49

FIre Panda

6,6272 gold badges28 silver badges39 bronze badges

Comments

Viral Sarvaiya · Accepted Answer · 2011-05-18 12:13:22Z

0

use this code for merge the dataset

dataSet.Merge(changeDataSet);

answered May 18, 2011 at 12:13

Viral Sarvaiya

7812 gold badges10 silver badges29 bronze badges

Collectives™ on Stack Overflow

GridView in ASP.NET

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related