I am developing a vb.net windows forms application.
I have a data grid view in this application, I am retreiving data into the data grid view using ado.net.
I added an extra column manually using code below:
Please help me the issues I have:
1.I am able to get the column in my data grid view, but it empty, I can understand that I haven't passed any data to the column so it is displaying empty(since this column is not from the database), what should I do inorder to set the default value in the column for all the rows as Zero '0'.
2.How can I restrict the user from entering characters, I want the user to enter only numeric values.
3.When I click a button all the values in all the rows of this column should change from '0' to '1'.
4.Is they any option to refresh the windows form for every 30 seconds.
I also have attached the data grid view ouput, where I have got the extra column without any data since it is not from the database.
If GetDataSet(DS, sSQL) Then
count = .Rows.Count
If .Rows.Count > 0 Then
dt = DS.Tables("Table")
RDGVW.DataSource = dt