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 in Web App

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

Thread Status:
Not open for further replies.
  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 spTEST", cs);
                
    
                cs.Open();
                da.Fill(ds);
                dg.DataSource = ds.Tables[0];
                   MessageBox("SUCCESS!");
                cs.Close();
               
            }
    
     
  2. shabbir

    shabbir Administrator Staff Member

Thread Status:
Not open for further replies.

Share This Page