data in datagridview is not updating

Question

0.00/5 (No votes)

See more:

sir i've written the code in c#:

C#

string constr = "Data Source=TUSHAR-PC;Initial Catalog=callcenter;Persist Security Info=True;User ID=sa;Password=password@123";
    SqlConnection con = new SqlConnection(constr);
    try
    {
        con.Open();
        string sql = "insert into tasks values('" + txtT_id.Text + "','" + txtname.Text + "','" + prir_txtbx.Text + "','" + stat_txtbx.Text + "','" + txtcomments.Text + "','" + dtpdue_date.Text + "','" + dtpcompletiondate + "')";
        SqlCommand cmd = new SqlCommand(sql, con);
        cmd.CommandType = CommandType.Text;
        cmd.ExecuteNonQuery();
        dataGridView1.DataSource = tasksBindingSource;
        con.Close();
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }

the data is stored in the sql server database that i have created . data is inserted to the database but the data in the datagridview is not updating.

Posted 18-Feb-13 21:41pm

tusharkaushik

Updated 18-Feb-13 21:44pm

Karthik Harve

v2

Add a Solution

Comments

Karthik Harve 19-Feb-13 3:45am

[Edit] added pre tags

Naveen.Sanagasetti 19-Feb-13 3:49am

Hi Karthik Harve , How to edit the question can you please tell me the steps..

Karthik Harve 19-Feb-13 3:54am

you can click on "Improve Question" link, that will redirect to edit screen, there you can edit the questions. Provided, you must have the privilege to edit the question, unless you are not original poster of the question.

Naveen.Sanagasetti 19-Feb-13 3:57am

this question is published by tusharkaushik , but in my screen it's not showing improve question option.

Karthik Harve 19-Feb-13 4:00am

that means, you do not have privileges to edit the question of the poster.

Naveen.Sanagasetti 19-Feb-13 4:02am

But now you can do that na..
To edit the tusharkaushik question na...

Karthik Harve 19-Feb-13 4:07am

currently, your authority points is 770, so, once it cross 1000 points, then your member level becomes silver. then you can also, edit the question.

Naveen.Sanagasetti 19-Feb-13 4:14am

Oh k k thank you , after that which option i selected for editing

Karthik Harve 19-Feb-13 4:21am

welcome. once you get that privilege, you make use of "Improve Question" link.

Naveen.Sanagasetti 19-Feb-13 4:22am

Thank's alot...

Karthik Harve 19-Feb-13 4:24am

most welcome. !!!

Surendra0x2 19-Feb-13 3:57am

Whats the Use of dataGridView1.DataSource = tasksBindingSource;
instead of Make FillDatagrid(); Method on Form Load

then Call it Anywhere to see Updated Data in Datagridview

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)

Naveen.Sanagasetti · Answer 1 · 2013-02-18T21:45:00

Solution 1

Try this,

C#

dataGridView1.DataSource = tasksBindingSource;
dataGridView1.DataBind();

Posted 18-Feb-13 21:45pm

Naveen.Sanagasetti

Comments

tusharkaushik 19-Feb-13 5:47am

but the method databinding() is not appeared.
what is the alternate method instead of databinding() method.

aliwpf · Answer 2 · 2013-02-18T21:47:00

Solution 2

Hi. after your Save operation finished ,you must Call Window_Loaded(sender,e);
I suppose your GridView in a Window.
Good Luck

Posted 18-Feb-13 21:47pm

aliwpf

*Karthik Harve* · Answer 3 · 2013-02-18T21:52:00

Hi,

try below code.

C#

con.Open();
string sql = "insert into tasks values('" + txtT_id.Text + "','" + txtname.Text + "','" + prir_txtbx.Text + "','" + stat_txtbx.Text + "','" + txtcomments.Text + "','" + dtpdue_date.Text + "','" + dtpcompletiondate + "');";

//to get the new rows.
sql += "SELECT * FROM tasks";  // replace * with column names of the table
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;
DataSet _objDataSet = new DataSet();
SqlDataAdapter  _objSqlDataAdapter = new SqlDataAdapter();     
cmd.CommandText = sql;
_objSqlDataAdapter.SelectCommand = _objSQLCommand;
_objSqlDataAdapter.Fill(_objDataSet);

dataGridView1.DataSource = _objDataSet.Table[0];
con.Close();

hope it helps

Surendra0x2 · Answer 4 · 2013-02-18T21:55:00

Solution 4

On Form_Load Create Method FillGridview();
then call it after insert

like

con.close();<br />
FillGridview();

Posted 18-Feb-13 21:55pm

Surendra0x2

Comments

tusharkaushik 19-Feb-13 5:49am

but i cant understand !
what should i write in the method fillgridview().

Surendra0x2 19-Feb-13 6:12am

Do like this-Bind data to Datagridview on formload
public void FillGrid()
{

using (SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=windowform;integrated security=true"))
{
SqlDataAdapter da = new SqlDataAdapter("select * from reg", sqlconn);
try
{
sqlconn.Open();

DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.AutoGenerateColumns = false;

dataGridView1.DataSource = ds.Tables[0];

}
catch (Exception ex)
{

MessageBox.Show(ex.ToString());

}
finally
{

if (sqlconn.State == ConnectionState.Open)
{

sqlconn.Close();
}

}
}

}

tusharkaushik 19-Feb-13 7:10am

but i'v developed in c# windows application

Surendra0x2 20-Feb-13 6:11am

look at the coding i used dataridview which is windows tool

data in datagridview is not updating

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us