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 ADO.NET serialization slower than ADO ?

1053

---

what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

1019

---

What is the namespaces being used to access oracle database?

1081

---

What providers does Ado.net uses?

1022

---

What is adodb dll?

1001

---

What is the executescalar method?

1101

---

What is data relation?

917

---

How can we load multiple tables in to dataset?

1090

---

What is the difference between the clone() and copy() methods of the dataset class?

1088

---

Why do we serialize data?

945

---

What is the difference between data grid and data repeater?

1079

---

What are the various methods provided by the DataSet object to generate XML?

1004

---

How would you connect to database using .NET?

1030

---

Explain the difference in record set and dataset?

939

---

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

1006

---