Breaking News: Grepper is joining You.com. Read the official announcement!

c# sqlite AddWithValue array

florinrelea answered on October 2, 2022 Popularity 1/10 Helpfulness 8/10

answer c# sqlite AddWithValue array

c# sqlite AddWithValue array

Comment

var parameters = new string[items.Length];
var cmd = new SqlCommand();
for (int i = 0; i < items.Length; i++)
{
    parameters[i] = string.Format("@Age{0}", i);
    cmd.Parameters.AddWithValue(parameters[i], items[i]);
}

cmd.CommandText = string.Format("SELECT * from TableA WHERE Age IN ({0})", string.Join(", ", parameters));
cmd.Connection = new SqlConnection(connStr);

Popularity 1/10 Helpfulness 8/10 Language csharp

Source: Grepper

Tags: c# sqlite

Link to this answer
Share Copy Link

Contributed on Oct 02 2022

florinrelea

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

c# sqlite AddWithValue array

Contents

More Related Answers

c# sqlite AddWithValue array

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.