Method name expected C# SQL Server visual studio 2019

Question

I'm trying to read data from the data source and I got this error in the ExecuteReader method, When I try to show the result in some label.

I'm getting the error here idlabel.Text = myraeder("id"); under myreader varibale

private void Searchbtn_Click(object sender, EventArgs e)
{
   SqlConnection con = new SqlConnection(dataConnectin);
   con.Open();

   string searchsql = "SELECT * from Table WHERE Name=" + searchtxt.Text + "";
   SqlCommand cmd = new SqlCommand(searchsql, con);

   SqlDataReader myraeder;
   myraeder = cmd.ExecuteReader();
   myraeder.Read();

   idlabel.Text = myraeder("id");
}

Use this one `myraeder["id"].ToString();` – hassan.ef Aug 16 '20 at 11:31 — hassan.ef, Aug 16 '20 at 11:31
Be aware of the sql injection possibility here. – Julian Aug 16 '20 at 11:43 — Julian, Aug 16 '20 at 11:43

score 1 · Answer 1 · answered Aug 16 '20 at 11:34

1

Use square brackets instead of round brackets.
Convert the field to string.

    idlabel.Text = myraeder["id"].ToString();

answered Aug 16 '20 at 11:34

Andrew Arthur

1,563
2
11
17

score 1 · Answer 2 · answered Aug 16 '20 at 11:40

1

Read the data in this way:

idlabel.Text = myraeder["id"].ToString();
con.Close();

And do not forget to close the connection after getting required data.

answered Aug 16 '20 at 11:40

Sh.Imran

1,035
7
13

Is it worked for you and your issue is resolved ? – Sh.Imran Aug 16 '20 at 15:40

score 1 · Answer 3 · answered Aug 16 '20 at 13:02

There are so many errors that are obvious. Let me show you a better way to write code. Follow me!

Give the variables proper names and casing.
Use asynchrony.
Use parameters in sql queries.
Release resources by wrapping them in using.
Enclose names in brackets in sql.

private async void SearchButton_Click(object sender, EventArgs e)
{
    using (var connection = new SqlConnection(connectionString))
    {
        await connection.OpenAsync();

        string searchSql = "SELECT * from [Table] WHERE [Name]=@name";

        using (var command = new SqlCommand(searchSql, connection))
        {
            command.Parameters.Add("name", SqlDbType.NVarChar).Value = searchTextBox.Text;

            using (var reader = await command.ExecuteReaderAsync())
            {
                while (await reader.ReadAsync())
                {
                    idLabel.Text = reader["id"].ToString();
                }
            }
        }
    }
}

Method name expected C# SQL Server visual studio 2019

3 Answers3