Steps to reproduce the behavior

1. In Microsoft Visual Studio .NET or in Microsoft Visual Studio 2005, use Visual Basic .NET, Visual Basic 2005, Visual C# 2005, or Visual C# .NET to create a new Windows Application project. By default, Form1 is created.
2. Add a DataGrid control to Form1.
   Note By default, the DataGrid control does not appear in Visual Studio 2005 toolbox. To obtain a DataGrid control, click Choose Toolbox Items on the Tools menu, click to select DataGrid on the .NET Framework Components tab, click Reset, and then click OK.
3. Add a Button object to Form1. By default, the Button1 object is created.
4. In design view, double-click Form1 to open the code for the Form1_Load event.
5. Add the following code before the Form1_Load event code to create a DataSet object.
   Visual Basic .NET code

       ' Create a data source.
       Private myDataSet As DataSet = New DataSet

   Visual C# .NET code

         // Create a data source.
         private DataSet myDataSet = new DataSet();

6. Replace the Form1_Load event code with the following code.
   Visual Basic .NET code

       Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
           ' Add a DataTable object to the DataSet object.
           myDataSet.Tables.Add("MyTable")
           myDataSet.Tables(0).Columns.Add("OriginalColumn")
           myDataSet.Tables(0).Rows.Add(New Object() {"Original Data"})
   
           ' Bind the DataGrid control to the data source.
           DataGrid1.SetDataBinding(myDataSet, "MyTable")
       End Sub

   Visual C# .NET code

      private void Form1_Load(object sender, System.EventArgs e)
      {
        // Add a DataTable object to the DataSet object.
        myDataSet.Tables.Add("MyTable");
        myDataSet.Tables[0].Columns.Add("OriginalColumn");
        myDataSet.Tables[0].Rows.Add(new Object[] {"Original Data"});
   
        // Bind the DataGrid control to the data source.
        dataGrid1.SetDataBinding(myDataSet, "MyTable");
      }

7. In Solution Explorer, right-click Form1, and then click View Designer.
8. In design view, double-click the Button1 object to add code for the Button1_Click event. Replace the code for the Button1_Click event with the following code.
   Visual Basic .NET code

       Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
           ' Remove the DataTable object from the data source.
           myDataSet.Tables.Clear()
          
          ' Add a DataTable object to the DataSet object.
           myDataSet.Tables.Add("MyTable")
           myDataSet.Tables(0).Columns.Add("NewColumn")
           myDataSet.Tables(0).Rows.Add(New Object() {"New Data"})
   
           'DataGrid1.DataSource = myDataSet.Tables("MyTable")
           DataGrid1.SetDataBinding(myDataSet, "MyTable")
       End Sub

   Visual C# .NET code

      private void button1_Click(object sender, System.EventArgs e)
      {
         // Remove the DataTable object from the data source.
         myDataSet.Tables.Clear();
      
         // Add a DataTable object to the DataSet object.
         myDataSet.Tables.Add("MyTable");
         myDataSet.Tables[0].Columns.Add("NewColumn");
         myDataSet.Tables[0].Rows.Add(new Object[] {"New Data"});
     
         // Bind the DataGrid control to the data source.
         dataGrid1.SetDataBinding(myDataSet, "MyTable");		
      }

9. On the Debug menu, click Start to run the application.
10. Click Button1. Notice that the original value appears in the DataGrid control.

Back to the top