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();

differance between ADO vs ADO.Net?

1136

---

Define data adapter?

1025

---

What is the return type of executescalar?

1074

---

What are the advantage of ado.net?

1046

---

How do you connect to sql server database without using sqlclient?

1176

---

Is ado.net dead?

1063

---

What are the advantages and drawbacks of using ado.net?

1156

---

What are the different methods available under the sqlcommand class to access the data?

1100

---

Explain how to create dynamic gridview?

1020

---

How to add an aggregate column?

1068

---

Which object of ado contains datarow datacolumn collection?

1014

---

What Is Difference Between Ado And Ado.net?

1083

---

Can we do database operations without using any of the ado.net objects?

1042

---

What is aggregate root?

1190

---

What is fill method in ado.net?

1038

---