1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

C# DataGrid Web App

Discussion in 'C#' started by C#newbie, Dec 6, 2011.

  1. C#newbie

    C#newbie New Member

    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();
               
            }
     

Share This Page