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

What are dataproviders?

902

---

How would you connect to a database by using .NET?

889

---

Which parameter of ConnectionString is used to specify the name of the database?

985

---

How can we perform transactions in .net?

992

---

Some important instruction regarding ADO.NET connection string ?

923

---

How to find the given query is optimised one or not?

915

---

What is ole access?

882

---

What are the core objects of ADO.NET?

978

---

Explain how to find the given query is optimised one or not?

947

---

What you mean by filtering of data?

900

---

What is dataset object? Explain the various objects in dataset.

979

---

What are the objects of ado.net?

1011

---

What does adodb stand for?

972

---

What are the pre-requisites for connection pooling?

954

---

What is sql connection in ado.net?

895

---