How to refresh Grid....?

Question

0.00/5 (No votes)

See more:

, +

I have one ASPX page and inside that one user control and that user control contains one grid to display the data, the data will load into grid view using DatasourceID and one sqldatasource control.

now my question is that when i add one record in that table that record is not shown in my grid, but when i refresh the page or reload the page at that time that record is displayed in grid.

so how to refresh the grid while we use a sqldatasource control.

C#

<asp:TextBox ID="txtName" runat="server">
    
    <asp:Button ID="btnSave" runat="server" Text="Save" OnClick="btnSave_Click" />

code behind is like this.

C#

protected void btnSave_Click(object sender, EventArgs e)
{   
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString.ToString());
    SqlDataAdapter da = new SqlDataAdapter();
    con.Open();
    da.InsertCommand = new SqlCommand();
    da.InsertCommand.Connection = con;
    da.InsertCommand.CommandType = CommandType.Text;
    da.InsertCommand.CommandText = "INSERT INTO [User] ([NAME]) VALUES (@NAME)";
    da.InsertCommand.Parameters.AddWithValue("@NAME", txtName.Text);            
    da.InsertCommand.ExecuteNonQuery();
    con.Close();
}

i have configured my sqldata source like this.

C#

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConStr %>"
        SelectCommand="SELECT * FROM [User]">

and my grid view is like this.

C#

<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">

In short... I want to refresh my grid when i insert the record to my grid.
I am using Oracle as my database.

Posted 30-Nov-11 1:39am

Tejas Vaishnav

Updated 30-Nov-11 1:42am

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Keith Barrow · Answer 1 · 2011-11-30T01:57:00

Solution 1

The problem is that the SqlDataSource is unaware of the changes so they do not propagate through to the grid.

One option is to perform the insert via the SqlDataSource[^] which will do the job with no code-behind in some [limited] circumstances.

A simpler method is to call GridView1.DataBind() after the insert code you have supplied.

Posted 30-Nov-11 1:57am

Keith Barrow

Comments

Tejas Vaishnav 30-Nov-11 8:12am

GridView1.DataBind() i tried this but its not work...
thanks for reply...

Eduard Lu · Answer 2 · 2011-11-30T14:31:00

Rebind the datasource after the save method.

private void SaveRecord()
{ 
   SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString.ToString());
    SqlDataAdapter da = new SqlDataAdapter();
    con.Open();
    da.InsertCommand = new SqlCommand();
    da.InsertCommand.Connection = con;
    da.InsertCommand.CommandType = CommandType.Text;
    da.InsertCommand.CommandText = "INSERT INTO [User] ([NAME]) VALUES (@NAME)";
    da.InsertCommand.Parameters.AddWithValue("@NAME", txtName.Text);            
    da.InsertCommand.ExecuteNonQuery();
    con.Close();
}

protected void btnSave_Click(object sender, EventArgs e)
{   
   SaveRecord();
   GridView1.DataSource = SqlDataSource1;
   GridView1.DataBind();
}

Regards,
Eduard

Ariel Riyo · Answer 3 · 2011-11-30T12:52:00

base in my own experience.

Call the data from the database again after your statement. that should work.

If you use this:

C#

protected void btnSave_Click(object sender, EventArgs e)
{   
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString.ToString());
    SqlDataAdapter da = new SqlDataAdapter();
    con.Open();
    da.InsertCommand = new SqlCommand();
    da.InsertCommand.Connection = con;
    da.InsertCommand.CommandType = CommandType.Text;
    da.InsertCommand.CommandText = "INSERT INTO [User] ([NAME]) VALUES (@NAME)";
    da.InsertCommand.Parameters.AddWithValue("@NAME", txtName.Text);            
    da.InsertCommand.ExecuteNonQuery();
    con.Close();
}

Try adding Some select command after it so logically speaking if you click the button save you will call again the data and now together with data just you inserted.

i hope it can help you. :)

**Manoj K Bhoir** · Answer 4 · 2011-11-30T18:13:00

Solution 4

Try this one at the end of your code :

C#

dataGridView1.Refresh();//To refresh gridview

Or another way you can use Update Panel(Ajax) for partial Page refreshing.
I hope it will help you. :)

Posted 30-Nov-11 18:13pm

Manoj K Bhoir

How to refresh Grid....?

4 solutions

Solution 1

Solution 3

Solution 2

Solution 4

Add your solution here

Preview 0