I got a problem about Gridview which was contained the Data inside Detailsview. These are my code.
string ShowJobItem = "Select JobItemID, JobItemStatus, JobItemName, JobItemDes, JobOrderItems.SizeID,SizeName,JobItemQty from JobOrderItems, Sizes where JobItemID = '" + GridView2.SelectedRow.Cells.Text + "' AND JobOrderItems.SizeID = Sizes.SizeID ;";
DataTable dt = dbconn.QueryExecuteScalar(ShowJobItem);
GridView GV = (GridView)DetailsView1.FindControl("GridViewJobOrderItem");
GV.DataSource = dt;
There was an error at "DataTable dt = dbconn.QueryExecuteScalar(ShowJobItem);" It show this error
Expression type int is invalid for COLLATE clause.
At first, I think it is because it cannot find the GridView, If there is UpdatePanel cover DetailView, So I tried to solve this problem by remove UpdatePanel. (It used to work well). But At this time, It s not work. So Is there any suggestions?
Thanks for your kindly help again and again.