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.
protected void Button2_Click1(object sender, EventArgs e)
da.SelectCommand = new SqlCommand("execute spINSERT_DATA", cs);
dg.DataSource = ds.Tables;
MessageBox("New Row is SUCCESS!");