how to solve the asp.net gridvew databound errors

Question

0.00/5 (No votes)

See more:

"Error 1 The event 'System.Web.UI.WebControls.BaseDataBoundControl.DataBound' can only appear on the left hand side of += or -= D:\my project\dmv\dmv\svf\Default.aspx.cs "
//Edit as per op's more detail

C#

SqlConnection con = new SqlConnection("Data Source=NSYS1\\SQLEXPRESS;Initial Catalog=agfl;connect timeout=30;Integrated Security=True"); 
con.Open(); 
string strQuery = "select * from stv where rdate =@Textbox6.text"; 
SqlCommand cmd = new SqlCommand(strQuery); 
cmd.CommandType = CommandType.Text; 
SqlDataAdapter sda = new SqlDataAdapter(cmd); 
cmd.Parameters.AddWithValue("@rdate", TextBox6.Text); 
DataSet ds = new DataSet(); 
sda.Fill(ds); 
DataTable dt = new DataTable(); 
dt = ds.Tables[0]; 
gvuser.DataSource = dt; 
gvuser.DataBound(); 
con.Close();

Posted 24-Oct-13 20:12pm

Raghavendra Guptha

Updated 24-Oct-13 20:35pm

Harshil_Raval

v2

Add a Solution

Comments

Harshil_Raval 25-Oct-13 2:16am

Update your question with more detail.

Raghavendra Guptha 25-Oct-13 2:26am

SqlConnection con = new SqlConnection("Data Source=NSYS1\\SQLEXPRESS;Initial Catalog=agfl;connect timeout=30;Integrated Security=True");
con.Open();
string strQuery = "select * from stv where rdate =@Textbox6.text";
SqlCommand cmd = new SqlCommand(strQuery);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@rdate", TextBox6.Text);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];
gvuser.DataSource = dt;
gvuser.DataBound();
con.Close();

Harshil_Raval 25-Oct-13 2:35am

On which line you are getting this exception?

Raghavendra Guptha 25-Oct-13 2:39am

gvuser.databound();

Harshil_Raval 25-Oct-13 2:40am

see this..
string strQuery = "select * from stv where rdate =@Textbox6.text";
replace @Textbox6.text with @rdate.

Khandwawala Hatim 25-Oct-13 2:23am

can you share your grid view code so that it makes more clear about the problem?

Raghavendra Guptha 25-Oct-13 2:26am

SqlConnection con = new SqlConnection("Data Source=NSYS1\\SQLEXPRESS;Initial Catalog=agfl;connect timeout=30;Integrated Security=True");
con.Open();
string strQuery = "select * from stv where rdate =@Textbox6.text";
SqlCommand cmd = new SqlCommand(strQuery);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@rdate", TextBox6.Text);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];
gvuser.DataSource = dt;
gvuser.DataBound();
con.Close();

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zafar Sultan · Answer 1 · 2013-10-24T20:36:00

Add connection string in your web.config file like:

HTML

<add name="MyConnectionString" connectionString="Data Source=ServerName;initial catalog=DatabaseName;Integrated Security=True;" providerName="System.Data.SqlClient" />

Update your code to:

C#

SqlConnection con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
con.Open();
string strQuery = "select * from stv where rdate = @rdate";
SqlCommand cmd = new SqlCommand(strQuery, con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@rdate", TextBox6.Text);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];
gvuser.DataSource = dt;
gvuser.DataBound();
con.Close();

It worked for me. Check if it works for you too.

Vishal Pand3y · Answer 2 · 2013-10-24T20:38:00

Solution 2

What are You Trying to do
do you want to bind the grid if so use above code

C#

using (SqlConnection con = new SqlConnection(Your Connection String))
{
    using (SqlCommand cmd = new SqlCommand())
    {
        cmd.CommandText = Your Command Text;
        cmd.Connection = con;
        con.Open();
        GridView1.DataSource = cmd.ExecuteReader();
        GridView1.DataBind();
        con.Close();
    }
}

ASP.NET

<Columns>
                                <asp:BoundField HeaderText="Your Header" DataField="Name Of Column or Model" />
 </Columns>

Hope this Helps...

Posted 24-Oct-13 20:38pm

Vishal Pand3y

Updated 25-Oct-13 2:15am

v2

Comments

Raghavendra Guptha 25-Oct-13 2:52am

wroking ok but notshowing gridview in asp.net page

Vishal Pand3y 25-Oct-13 3:06am

Can u show your Code of aspx page....

Raghavendra Guptha 25-Oct-13 8:08am

<asp:GridView ID="gvuser" runat="server" AutoGenerateColumns="False" PageSize="10"
Width="1017px" Caption="Settlement vouchers Feeding Details" AllowPaging="true"
>
<columns>
<asp:TemplateField HeaderText="S.No">
<itemtemplate>
<asp:Label ID="label1" Visible="true" runat="server" Text='<%# Eval("sno") %>'>

<asp:TemplateField HeaderText="RDATE">
<itemtemplate>
<asp:Label ID="label2" Visible="true" runat="server" Text='<%# Eval("rdate") %>'>

<asp:TemplateField HeaderText="ACNO">
<itemtemplate>
<asp:Label ID="label3" Visible="true" runat="server" Text='<%# Eval("acno") %>'>

<asp:TemplateField HeaderText="NAME">
<itemtemplate>
<asp:Label ID="label4" Visible="true" runat="server" Text='<%# Eval("name") %>'>

<asp:TemplateField HeaderText="VNO">
<itemtemplate>
<asp:Label ID="label5" Visible="true" runat="server" Text='<%# Eval("vno") %>'>

<asp:TemplateField HeaderText="AMOUNT">
<itemtemplate>
<asp:Label ID="label6" Visible="true" runat="server" Text='<%# Eval("amt") %>'>

<asp:TemplateField HeaderText="EDATE">
<itemtemplate>
<asp:Label ID="label7" Visible="true" runat="server" Text='<%# Eval("edate") %>'>

<asp:TemplateField HeaderText="CHNO">
<itemtemplate>
<asp:Label ID="label8" Visible="true" runat="server" Text='<%# Eval("chno") %>'>

Vishal Pand3y 25-Oct-13 8:13am

it seems to be fine but for better practice use BoundField instead of TemplateField
see my Updated Solution

Vishnu Prajapati · Answer 3 · 2013-10-24T20:49:00

Solution 3

I Think this is very useful to us:
---------------------------------------

1> http://docs.oracle.com/cd/E17952_01/refman-5.5-en/connector-net-tutorials-entity-framework-databinding-linq-entities.html[^]

Posted 24-Oct-13 20:49pm

Vishnu Prajapati

C For Code!!! · Answer 4 · 2013-10-24T23:45:00

replace your following code .....

C#

string strQuery = "select * from stv where rdate = @rdate";
SqlCommand cmd = new SqlCommand(strQuery, con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@rdate", TextBox6.Text);
DataSet ds = new DataSet();
sda.Fill(ds);

By-

C#

string strQuery = "select * from stv where rdate = "+"'"TextBox6.Text"'";
SqlCommand cmd = new SqlCommand(strQuery, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);

Hope This Helps!!!