Read a specific row from database using a variable

Question

I have troubles reading an specific row from database.

I have an integer ni and I want to read only this ni row from the SQL Server database (if ni = 3 I need to read the third row).

private void intrebarea(int ni)
{
    con.Open();

    SqlCommand cmd = new SqlCommand("Select * from tbl", con);

    SqlDataReader rdr = cmd.ExecuteReader();
    rdr.Read();
}

I thought it is possible to use

SqlCommand cmd = new SqlCommand("Select * from tbl WHERE id=ni", con);

but obviously it doesn't work.

Any ideas, please?

Community · Accepted Answer · 2017-05-23 11:52:08Z

3

The best approach is to use parameters: your query will be faster and it will avoid SQL injection.

Take a look:

private void intrebarea(int ni)
{
    con.Open();
    SqlCommand cmd = new SqlCommand("Select * from tbl Where Id = @Id", con);
    cmd.Parameters.Add(new SqlParameter("@Id", System.Data.SqlDbType.Int)));
    cmd.Parameters["@Id"].Value = ni;
    SqlDataReader rdr = cmd.ExecuteReader();

    rdr.Read();
}

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Aug 30, 2015 at 14:04

Il Vic

5,6564 gold badges28 silver badges38 bronze badges

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

1 Comment

Macpp Over a year ago

This is what I needed. Thak you!

Andrey · Accepted Answer · 2015-08-30 13:22:43Z

0

If I understand you right you should use:

SqlCommand cmd = new SqlCommand(string.Format("Select * from tbl where id={0}", ni), con);

answered Aug 30, 2015 at 13:22

Andrey

1182 silver badges11 bronze badges

Collectives™ on Stack Overflow

Read a specific row from database using a variable

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related