Hello,
I'm using databindings to display data from a datatable.
When I first fill my datatable, it works perfectly, and displays the
current data.
If I remove the datatable, and recreate it with new data, it's not
working anymore : the displayed data are from the first fill of the
Datatable ! (I checked, it's not the same DataTable anymore).
Here's my code :
SqlDataAdapter sqlda = new SqlDataAdapter("SELECT * From Data",Cnx);
if (GlobalDS.Tables.Contains("Data"))
{
GlobalDS.Tables.Remove("Data");
}
sqlda.Fill(GlobalDS, "Data");
txtName.DataBindings.Clear();
txtName.DataBindings.Add("Text",
GlobalDS,"Data.Name");
Thanks,
Jerry H. - 28 Sep 2006 21:50 GMT
Why do you remove the table? If you want to refresh it, you can just
call tblTableName.clear to remove the data from it and then call the
Fill method to reload data.
> Hello,
>
[quoted text clipped - 18 lines]
>
> Thanks,
Guillaume JAY - 29 Sep 2006 07:42 GMT
>Why do you remove the table? If you want to refresh it, you can just
Because I didn't know better :)
>call tblTableName.clear to remove the data from it and then call the
>Fill method to reload data.
I'll try that.
I currently solved the problem by recreating the dataset.
I'm surprised I couldn't find any posts on this problem.
Thanks,