Validate a register on SQL Server and C#

The SQL part

select * from yourtable where yourcolumn=yourvalue

It's easy to poor this into a stored procedure. Create a new SP, press M and fill in the details; pay attention to the first parameter, give it a sensible name and make it the right type (e.g. nvarchar(50))
Paste above sql query at the right place in the stored procedure. Replace yourvalue above by @p1 (or the sensible name that you gave it) and remove the stuff that you don't want (e.g. p2 and the default select that SSMS puts in there).

The C# part will look like this (I assume that you know how to setup a connection

SqlCommand cmd = new SqlCommand("nameofyoursp", yourConnection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p1", yourvaluetocheck);

DataTable tbl = new DataTable();
tbl.Load(cmd.ExecuteReader());

If tbl has one or more rows, yourvalue exists in the table 'yourtable' in the database.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Wim Sturkenboom12y ago
The SQL part

select * from yourtable where yourcolumn=yourvalue

It's easy to poor this into a stored procedure. Create a new SP, press M and fill in the details; pay attention to the first parameter, give it a sensible name and make it the right type (e.g. nvarchar(50))
Paste above sql query at the right place in the stored procedure. Replace yourvalue above by @p1 (or the sensible name that you gave it) and remove the stuff that you don't want (e.g. p2 and the default select that SSMS puts in there).

The C# part will look like this (I assume that you know how to setup a connection

SqlCommand cmd = new SqlCommand("nameofyoursp", yourConnection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p1", yourvaluetocheck);

DataTable tbl = new DataTable();
tbl.Load(cmd.ExecuteReader());

If tbl has one or more rows, yourvalue exists in the table 'yourtable' in the database.