How to add parameters in c# 2.0? What is the difference between to add parameter in c# 1.1 and 2.0!
To add Parameters in C# 1.1
SqlConnection myConnection=new SqlConnection(ConnString); //define connection object
myConnection.Open();//open connection
SqlCommand objSqlCommand=new SqlCommand("stored_procedure_name",myConnection); //cretae command object
objSqlCommand.CommandType=CommandType.StoredProcedure;
objSqlCommand.Parameters.Add("@paramName",ParamValue); //Assign Parameter value
objSqlDataReader=objSqlCommand.ExecuteReader();
while(objSqlDataReader.Read())
{
strVariable=objSqlDataReader["FieldName"].ToString(); // reading value
}
To add Parameters in C# 2.0
SqlConnection myConnection=new SqlConnection(ConnString); //define connection object
myConnection.Open();//open connection
SqlCommand objSqlCommand=new SqlCommand("stored_procedure_name",myConnection); //cretae command object
objSqlCommand.CommandType=CommandType.StoredProcedure;
SqlParameter objSqlParameter = new SqlParameter("@paramName", SqlDbType.VarChar); //define varibale type
objSqlParameter.Value = strDomainName; //assign value to parameter
objSqlCommand.Parameters.Add (objSqlParameter); // add parameter
objSqlDataReader=objSqlCommand.ExecuteReader();
while(objSqlDataReader.Read())
{
strVariable=objSqlDataReader["FieldName"].ToString(); // reading value
}
SqlConnection myConnection=new SqlConnection(ConnString); //define connection object
myConnection.Open();//open connection
SqlCommand objSqlCommand=new SqlCommand("stored_procedure_name",myConnection); //cretae command object
objSqlCommand.CommandType=CommandType.StoredProcedure;
objSqlCommand.Parameters.Add("@paramName",ParamValue); //Assign Parameter value
objSqlDataReader=objSqlCommand.ExecuteReader();
while(objSqlDataReader.Read())
{
strVariable=objSqlDataReader["FieldName"].ToString(); // reading value
}
To add Parameters in C# 2.0
SqlConnection myConnection=new SqlConnection(ConnString); //define connection object
myConnection.Open();//open connection
SqlCommand objSqlCommand=new SqlCommand("stored_procedure_name",myConnection); //cretae command object
objSqlCommand.CommandType=CommandType.StoredProcedure;
SqlParameter objSqlParameter = new SqlParameter("@paramName", SqlDbType.VarChar); //define varibale type
objSqlParameter.Value = strDomainName; //assign value to parameter
objSqlCommand.Parameters.Add (objSqlParameter); // add parameter
objSqlDataReader=objSqlCommand.ExecuteReader();
while(objSqlDataReader.Read())
{
strVariable=objSqlDataReader["FieldName"].ToString(); // reading value
}
Comments