DataGridView doesent refresh

Yes, certainly the database will be updated; that is the primary purpose of doing that. The secondary purpose is to update the controls bound to the data source.

I know it can be frustrating figuring out how to use TableAdapters.

Ok thanks, I'll try it this way - I just have a one question, will the data I enter into DataSet this way be also added to database.

I'm adding data by ExecuteCommand method of DataContext class:

PDC.ExecuteCommand("INSERT INTO MyTable VALUES ('" + Convert.ToString(DateTime.Now) + "','" + Convert.ToString(this.comboBox1.SelectedItem) + "-" + Convert.ToString(this.comboBox2.SelectedItem) + "','" + Convert.ToString(this.comboBox3.SelectedItem) + "','" + this.textBox4.Text + "','" + this.textBox5.Text + "')"); 

You do not need to do it that way. If you just provided the clarification I needed then I would provide the clarification you need to do it the way it should be done.

Hey
 
I managed to get it working by declaring a DataSet variable, and whenever I insert a new entry into the database I fill that variable with the content's of the database, and set the dataGridView's to pull it's data from this new variable. This is the part of code that does the trick:
//Declaration
SqlCommand cmd = new SqlCommand();
SqlConnection conn;
SqlDataAdapter SDA = new SqlDataAdapter();

//In the button which triggers the refreshment
cmd.Connection = conn;
cmd.CommandText = @"SELECT * FROM MarpromTablica_v_1_1";
SDA.SelectCommand = cmd;
SDA.Fill(spremnik);
dataGridView1.DataSource = spremnik.Tables[0].DefaultView;

Thanks to everybody who commented, it's been a lot of help.

No, Vineet; that is not how to use TableAdapters. Neven is already doing things without using the TableAdapter and related classes that should be done using the TableAdapter and related classes; for example,  AcceptChanges should not be called directly.

Dear Neven Draskovic ...

You have to do one of the following:

1. Add new value to DataGridViews DataSource. If the DataSource is a BindingList, the grid will be automatically notified of the new value. If not, use a BindingSource and invoke "ResetBindings".

2. Repopulate the DataGridView DataSource from the database.











thanks...

Are you using the TableAdapter to add data? You say that you are using myDataTableDataAdapter.Fill(myDataSet.myDataTable), myDataSet.AcceptChanges and .GetChanges but you still have not specified how you do the actual adding of the data.

Actually, I tried to use TableAdapter to refill the data table from which my dataGridView takes it's data. I used the syntax:
myDataTableDataAdapter.Fill(myDataSet.myDataTable)
Where myDataTable is a table in a database, and myDataSet is connected to it. If I'm correct, I am missing a step in my code - I had some problems with connecting my program to a database, but I finally figured it out, so I am 100% sure that the data I input from my form is indeed stored in my database (I managed to do an ExecuteQuery and it produced a correct result). So database is getting it's data correctly (that would be step 1) and whenever I close and run my application, the newly added data is displayed correctly. I added the functions myDataSet.AcceptChanges and .GetChanges and after that the boolean HasChanges - I wanted to get the message if the DataSet was changed in any way - but I never got that message, so obviously I missed one step.
Any advice on what that step might be, and how do I make it work?

It is good that you are using a bound form; a form bound to a data source. I think the other members attempting to help you are not familiar with bound forms.

I assume you are not using the Entity Framework; in other words, your data source is a TableAdapter. For anyone that want more information about that, one place to start is my Database Table Update in a DataGridView without Writing Code.

Are you using the TableAdapter to add data? Probably not. If you did, then the data in the data source would be automatically updated and the DataGridView would be be automatically updated. I forget the details of how to use a TableAdapter to insert data but I can refer to my programs if necessary. The general idea is that there is a Rows collection and you simply add new rows to the Rows collection and then you call a function to write the modifications to the database. If you do that then the records will be added efficiently and the controls wil also be updated as you expect.

If you need clarification of any of that, then please state explicitly if your data source uses a TableAdapter or the Entity Framework.

Unfortunately I cannot share my code, because the workstation I'm programming on has no Internet access, nor can I copy the code with USB or some other way.

Also, I see you are using SqlClient methods - I'm trying to avoid it because when I try to connect to my database with connection string I get an exception message size of a house. I think something is wrong with my SQL Server 2005 installation, but unfortunetly I cannot change that.

Can you think of another way to do this

Hi Neven,


Can your share your code.

Try this...

private void btninsert_Click(object sender, System.EventArgs e)
{
con.Open();
str = "insert into student values('" + txtid.Text.Trim() + "','" + txtname.Text.Trim() + "'," + txtmarks.Text.Trim() + ",'" + txtaddress.Text.Trim() + "','" + txtyear.Text.Trim() + "')";
com = new SqlCommand(str, con);
com.ExecuteNonQuery();
con.Close();
MessageBox.Show ("Records Successfuly Inserted");
bindgrid();

}

void bindgrid()

{
con.Open();
str="select * from student";
com=new SqlCommand(str,con);
sqlda=new SqlDataAdapter(com);
ds=new DataSet();
sqlda.Fill(ds,"student");
dataGridView1.DataSource=ds;
dataGridView1.DataMember=("student");
con.Close();
}


Thanks

Hm I dont understand what you mean. I'm using the following command to insert data into the database from my WinForm:

ProbniDataContext PDC = new ProbniDataContext("addres of database");

In button1_click method (that is used to execute the command):

PDC.ExecuteCommand(INSERT INTO....)

This part works fine, when I click on a button and exit the application, I can see my entry in the database, and if I close and restart the application the data shows up in the DataGridView as expected.

For the second part - I'v made a DataGridView that uses a table from that database (it is a simple database, has only one table) as DataSource, and whenever I start my application, it takes the data and displays it. The problem I'm encounterig is that when I add a new entry during runtime, the DataGridView doesent respond to it. I'v added a second button that should tell the DataGridView control that there is new data in database and that it should refresh it self. Now, I know that dataGridView.Refresh() only redraws the control, it doesent do anything to the datasource and its contents.

My question is - how can I make the DataGridView display the data I'v added during runtime - I expect that I have to refresh it's Datasource, but I don't know how to do it.

pls ensure you have selected data after save into database.