SQL Datareader failed to bind data to GridView

Question

protected void Button1_Click(object sender, EventArgs e)
{
    string query = "select * from aspnet_Users where userName like '%@UserName%'";
    connection.Open();
    SqlCommand command = new SqlCommand(query, connection);
    command.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = TextBox1.Text;
    SqlDataReader reader = command.ExecuteReader();
    GridView1.DataSource = reader;
    GridView1.DataBind();
    connection.Close();
}

I am trying to use connected model to search a user's data in a table but the GridView is always, never fills with data.

@serv - '%@UserName%' will be taken as a literal comparison and the value of the parameter will not be replaced. — ughai
– ughai, Commented Apr 17, 2015 at 7:35
check the value of the 1st column DECLARE @UserName VARCHAR(10) ='hi' SELECT'%@UserName%' ,'%' +@UserName + '%' — ughai
– ughai, Commented Apr 17, 2015 at 7:37

Rahul Singh · Accepted Answer · 2015-04-17 07:38:16Z

1

You parameter is acting as a string in your query because of single quotes you have include around the parameter. That is the reason it is not able to identify the parameter. Try this:-

string query = "select * from aspnet_Users where userName LIKE @UserName";

Then add it as parameter like this:-

command.Parameters.Add("@MyName",SqlDBType.NVarChar,40).Value ="%" + TextBox1.Text + "%";

edited Apr 17, 2015 at 7:38

answered Apr 17, 2015 at 7:33

Rahul Singh

21.8k6 gold badges43 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rahul Singh Over a year ago

@ÃhmëdSäßrý - What is the error message you are getting?

Rahul Singh Over a year ago

@ÃhmëdSäßrý - Have you debugged the code? Are you getting any data. Please debug and check if you hitting the correct DB and if you are getting the records.

Satinder singh · Accepted Answer · 2015-04-17 11:40:17Z

0

You can populate gridview using SqlDataAdapter, your code look like this

        string query = "select * from aspnet_Users where userName like '%@UserName%'";
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = query;
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@UserName", TextBox1.Text);
        cmd.Connection = conn;
        SqlDataAdapter dap = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        GridView1.DataSource = ds.Tables[0];
       GridView1.DataBind();

edited Apr 17, 2015 at 11:40

answered Apr 17, 2015 at 8:03

Satinder singh

10.2k18 gold badges64 silver badges102 bronze badges

2 Comments

Ãhmëd Säßrý Over a year ago

I don't recommend using disconnected model with asp.net because it may cause a bottleneck problems.

Ãhmëd Säßrý Over a year ago

But though, I tried it and there is exception 'Cannot find table 0.

Collectives™ on Stack Overflow

SQL Datareader failed to bind data to GridView

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related