Call a stored procedure from ado.net and pass parameter to it ?
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();
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What are three methods for displaying data in a syncfusion datagrid
What is ado.net full form?
List the 4 common ado.net namespaces?
What is sqldatasource?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
Which architecture does Datasets follow?
Describe the disconnected architecture of ADO.NET’s data access model.
What are the different ado.net namespaces are available in .net?
What is sqldatareader in ado.net?
What are the difference between readonly vs. Const?
What are all the classes that are available in System.Data Namespace?
What is difference between datareader and dataadapter?
What is ado full form?
How to pass multiple tables in datasets simultaneously?
What we do with the object of ado.net dataset after using it?