Answer Posted / dinesh gupta

string
ConnectionString= "server="+DatabaseSrvr+";database="+Datab
aseNam+";user id="+DatabaseUsr+";password="+DatabasePass
;

Sqlconnection Cn = new SqlConnection(ConnectionString);
Cn.Open();

SqlCommand cmd = new SqlCommand("PROCNAME", Cn);

cmd.CommandType = CommandType.StoredProcedure;

SqlParameter p = new SqlParameter();

p = new SqlParameter();
p.ParameterName = "@parameter1";
p.SqlDbType = SqlDbType.VarChar;
p.Size = 10;
p.Value = "abc";
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);

p = new SqlParameter();
p.ParameterName = "@parameter2";
p.SqlDbType = SqlDbType.Int;
p.Value = Convert.ToInt16(textbox.text);
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);


cmd.ExecuteNonQuery();

Why is it important to close an ado.net application?

1014

---

What does executereader return?

964

---

What is a dataview?

968

---

differences between ADO and ADO.NET

1066

---

What is executequery?

946

---

How can we perform transactions in .net?

1056

---

What does ado stand for?

903

---

How to add an aggregate column?

1005

---

What is the role of the dataset object in ado.net?

1103

---

How to aggregating data across related tables?

1033

---

How would you connect to database using .NET?

1026

---

describe the dataset object in ado.net.

952

---

What is the difference between an ADO.NET Dataset and an ADO Recordset?

1039

---

Define different execute methods of ADO.NET command object ?

1080

---

What is full form of ado?

1052

---