Call a stored procedure from ado.net and pass parameter to it ?
- 7 Answers
- 22445 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 the methods of XML dataset object?
Why do we use sqldataadapter?
Which database is the ado.net?
Explain the namespaces in which .net has the data functionality class.
How do you connect to sql server database without using sqlclient?
What is the difference between executenonquery () and executescalar ()?
How to connect and retrieve data from database using dataset
What is bubbled event can you please explain?
What is connection in ado.net?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
How would you connect to a database by using .NET?
What is dataset and datatable in ado.net?
Describe the disconnected architecture of ADO.NET’s data access model.
What is ado.net objects?
What is ado.net code?
