C# Winforms - How to Pass Parameters to SQL Server Stored Procedures

Question

my practice is that i fill use databinded listboxes and using a tablebindingsource and tableadapter. Then to get selective records in listbox i build stored procedure and select required records.

But now i want that the stored procedure must take some parameter from some textbox value.

like i to implement the following query

string query = "SELECT Patient_ID, Patient_Name FROM Patient WHERE ( Patient_Name LIKE '"+ textbox1.Text +"%' )";

how to do it in a stored procedure. cuz what i know is that i can only give a query like this in stored procedure

SELECT Patient_ID, Patient_Name FROM dbo.Patient WHERE ( Patient_Name LIKE 'DAV%' )

And then you make a stored procedure and fill the tableadapter with that stored procedure. like

this.accountsTableAdapter.FillBy_I(this.junaidDataSet.Patient);

My knowledge is limited ti Visual Studio 2008's interface and how to do stuff on it.

F1F1

Asad · Accepted Answer · 2010-02-11 10:18:07Z

1

you will have to pass a parameter using out / ref keyword and parameters

As yo are using TableAdapters, you need to select the storedproceedure rather than a query for this operation.

when you select that, it will recognise the parameters itself.

when you call the method over your TableAdapter, which is SelectByName in this case, it is going to be something similar . Modify accordingly

// your TableAdapter
PatientTableAdapter adapter = new PatientTableAdapter();


// your input and output variables
string name = "somePatientName";
int patientID? = 0;
string returnedName? = "";

// TableAdapter Method, wired to Stored Proceedure
adapter.SelectByName("somePatientName", out patientID, out returnedName);

hope this helps

edited Feb 11, 2010 at 10:18

answered Feb 11, 2010 at 10:08

Asad

22k17 gold badges73 silver badges94 bronze badges

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

2 Comments

Moon Over a year ago

and the query in the stored procedure will be like ?

Asad Over a year ago

query is of your choice, I do not know your requirements Objects / DB / Tables. just keep in mind to pass on the right parameters to the method which is wired to SP.

Collectives™ on Stack Overflow

C# Winforms - How to Pass Parameters to SQL Server Stored Procedures

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related