DataBind doesn't fire on GridView

Stanislav Godin

11y2.6k.NET

I have a very strange problem. I am developing the ASP.Net C# WebForm. I have a GridView with a sqldatasource and a textbox where I set a parameter from to the datasource. If I set the datasource on the GridVeiw itself, it works fine. I send a parameter and bind the GridView. I need to have a button and fire the DataBind() event from there. I had this scenario before and everything worked OK on other GridView's. So, I remove the datasource from the GridView and leave it with None, I put a button and placed my code there:

DetailsView1.DataSource = "GetRegisteredUser";
DetailsView1.DataBind();

When I hit the button, I am getting the message below. Just to clarify, the EmpID is my first column of the query.

DataBinding: 'System.Char' does not contain a property with the name 'EmpID'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: DataBinding: 'System.Char' does not contain a property with the name 'EmpID'.

Source Error:

Line 26: WebMsgBox.Show(TextBox1.Text); Line 27: DetailsView1.DataSource = "GetRegisteredUser"; Line 28: DetailsView1.DataBind(); Line 29: //} Line 30: }

Source File: c:\Users\sgodin\Documents\Visual Studio 2010\WebSites\MaskFitAdmin\EHMaskSizeSet.aspx.cs Line: 28

Stack Trace:

[HttpException (0x80004005): DataBinding: 'System.Char' does not contain a property with the name 'EmpID'.] System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) +9805821 System.Web.UI.WebControls.DetailsView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +1444 System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +67 System.Web.UI.WebControls.DetailsView.PerformDataBinding(IEnumerable data) +12 System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +123 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +33 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +138 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +30 System.Web.UI.WebControls.DetailsView.DataBind() +4 EHMaskSizeSet.Button1_Click1(Object sender, EventArgs e) in c:\Users\sgodin\Documents\Visual Studio 2010\WebSites\MaskFitAdmin\EHMaskSizeSet.aspx.cs:28 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9752490 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +196 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

I set up a profiler and when I run my app,. nothing gets executed. That means the DataBind() doesn't fire. The GridView expects the data where the first row is EmpID and it is not there.

What is wrong happening here? As I said, I used that method before and everything worked just fine.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Stanislav Godin11y ago
I think a lot of people lose what I say here. On one project in a web form I bind a GridView with a datasouce using quotes like this:

DetailsView1.DataSource = "GetRegisteredUser";
DetailsView1.DataBind();

GetRegisteredUser is a SqlDataSource defined on the web form.

In another project in a different web form I can't do the quotes. Look at the error above. I have to do this:

DetailsView1.DataSource = GetRegisteredUser;
DetailsView1.DataBind();

Why Microsoft allows passing the SqlDataSource using quotes in one form and doesn't allow it in another form? I have the same namespaces for both forms, and the web config files are the same except the server name.
0
Khargesh Rajput11y ago
what is your GetRegisteredUser

use any dataset or datatable as a valid datasource and bind with return data you want in gridview
0
Francis Susaimichael11y ago
"DataSource" property expects an datasource in the form of DataSet/datatable or any valid form of source. In your case, you have initially gave string as a datasource, which is not a valid one. Hope that the method "GetRegisteredUser" has a return type of Dataset/datatable. So when you give that method name, it works fine. Implicitly you gave "dataset/datatable". Hope you understand if you have any clarification let me know.
0
Stanislav Godin11y ago
The weirest part is this. In one of my web forms I pass the datasource name with the quotes as I posted here. After playing with that code on my current project, I removed the quotes and pass the datasource name as:

DetailsView1.DataSource = GetRegisteredUser;
DetailsView1.DataBind();

Now, it worked! So, why in the worlds, it works with quotes in one web form and not in another web form? All the namespaces are identical, the dot net framework is the same and the web config files are the same.
0