Interested to Buy Any Domain ? << Click Here >> for more details...
Call a stored procedure from ado.net and pass parameter to it ?
- 7 Answers
- 24675 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
Answer Posted / vagdevi
By using the SQLHelper of Microsoft,
in Business Layer import Microsoft.ApplicationBlocks.Data
and then,
Create properties for the parameters as userid,password
Declare a parameter array of Type SqlParameter as,
SqlParameter[] p=new SqlParameter[2];
p[0]=new SqlParameter("@userid",userid");
p[0].DbType=DbType.String;
p[0].Direction=ParameterDirection.Input;
p[1]=new SqlParameter("@password",password");
p[1].DbType=DbType.String;
p[1].Direction=ParameterDirection.Input;
SqlHelper.ExecuteNonQuery
(ConnetionString,CommandType.StoredProcedure,"StoredProcedur
eName", p);
That's it and call this method in your Presentation Layer
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What are dcl commands?
What is dataadapter in ado.net?
What is the executescalar method?
What are all components of ADO.Net data provider?
What is a datareader object?
Why is ADO.NET serialization slower than ADO ?
How to connect and retrieve data from database using dataset
Can you explain how to enable and disable connection pooling?
What are the connected and disconnected modes in ado.net?
What is the difference between data grid and data repeater?
What are two important objects of ADO.Net?
What is a serialized object?
How to generate a single aggregate?
What are the important features of ado.net 2.0?
What are the major challenges in accessing data from a database?
