1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

C# DataGrid Web App

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

  1. C#newbie

    C#newbie New Member

    Joined:
    Dec 6, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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