Go4Expert

Go4Expert (http://www.go4expert.com/)
-   C# (http://www.go4expert.com/forums/c-sharp/)
-   -   C# DataGrid Web App (http://www.go4expert.com/forums/c-sharp-datagrid-web-app-t27298/)

C#newbie 6Dec2011 20:05

C# DataGrid Web App
 
Does anyone know the issue with this code. I am trying to to display a datagrid from a stored procedure on a button click in the WebApp using C#. I have used this code developing a form and it worked perfect but won't translate to the WebApp . My connections are are set up correctly.

cs is my connection
da is my DataAdapter
ds is my Dataset
MessageBox is declared in a previous class and works correctly.

The stored procedure executes correctly because I have checked my tables in the database that update on the button click. I just want to display the results on my WebApp.

Any suggestions?

Code:

  protected void Button2_Click1(object sender, EventArgs e)
        {
            da.SelectCommand = new SqlCommand("execute spINSERT_DATA", cs);
           

            cs.Open();
            da.Fill(ds);
            dg.DataSource = ds.Tables[0];
              MessageBox("New Row is SUCCESS!");
            cs.Close();
         
        }



All times are GMT +5.5. The time now is 00:25.