C# Datagrid Blank

[rex64]

I created a datagrid and it worked great in the regular C#. But when I
do the exact same thing in ASP it does not work.

private void btnSignUp_Click (object sender, System.EventArg s e)
{
string connectionStrin g="data source=JEFF-3KQH2O8TJF;init ial
catalog=studyXS QL3;Integrated Security=SSPI";
SqlConnection studyXconnectio n=new SqlConnection(c onnectionString );
string selectStatement = "SELECT postID, userName, Post, Date,
Views "
//+ "ProductTot al, SalesTax, ShippingAndHand ling, InvoiceTotal "
+ "FROM Posts ";
// + "WHERE CustomerID = @CustomerID "
// + "ORDER BY InvoiceID";
//studyXconnectio n.Open();
//SqlCommand selectCommand = new SqlCommand(sele ctStatement,
studyXconnectio n);
//selectCommand.E xecuteNonQuery( );
SqlDataAdapter invoicesDataAda pter = new
SqlDataAdapter( selectStatement , studyXconnectio n);
DataSet invoicesDataSet = new DataSet();
invoicesDataAda pter.Fill(invoi cesDataSet, "Posts");
grdPosts.AutoGe nerateColumns = true;
grdPosts.DataSo urce = invoicesDataSet .Tables["Posts"];
invoicesDataAda pter.Update(inv oicesDataSet,"P osts");
//grdPosts.
//studyXconnectio n.Close();
}

[Chris Jobson]

"rex64" <st****@gmail.c om> wrote in message
news:11******** **************@ v46g2000cwv.goo glegroups.com.. .

I created a datagrid and it worked great in the regular C#. But when I
do the exact same thing in ASP it does not work.

private void btnSignUp_Click (object sender, System.EventArg s e)
{
string connectionStrin g="data source=JEFF-3KQH2O8TJF;init ial
catalog=studyXS QL3;Integrated Security=SSPI";
SqlConnection studyXconnectio n=new SqlConnection(c onnectionString );
string selectStatement = "SELECT postID, userName, Post, Date,
Views "
//+ "ProductTot al, SalesTax, ShippingAndHand ling, InvoiceTotal "
+ "FROM Posts ";
// + "WHERE CustomerID = @CustomerID "
// + "ORDER BY InvoiceID";
//studyXconnectio n.Open();
//SqlCommand selectCommand = new SqlCommand(sele ctStatement,
studyXconnectio n);
//selectCommand.E xecuteNonQuery( );
SqlDataAdapter invoicesDataAda pter = new
SqlDataAdapter( selectStatement , studyXconnectio n);
DataSet invoicesDataSet = new DataSet();
invoicesDataAda pter.Fill(invoi cesDataSet, "Posts");
grdPosts.AutoGe nerateColumns = true;
grdPosts.DataSo urce = invoicesDataSet .Tables["Posts"];
invoicesDataAda pter.Update(inv oicesDataSet,"P osts");
//grdPosts.
//studyXconnectio n.Close();
}

Not sure, but I think you have to call grdPosts.DataBi nd() after setting
grdPosts.DataSo urce.

Chris Jobson

[rex64]

Yup, that is all it was. Thanks a million!!!!!!!! You dont know how
much time I spent trying to get this to work.

[tdavisjr]

Seeing this type of code makes me wonder. I sure hope this is sample
code and not placed in production, this would be a total nightmare to
maintain if it was.