第一种:
SqlCommand cmd = New SqlCommand();
SqlDataReader dr;
cmd.CommandText = "Select * From tableName Where ID = @ID"
cmd.Parameters.Add(New SqlParameter("@ID",Convert.ToInt32(28)))
dr = cmd.ExecuteReader()
第二种形式 :
SqlCommand cmd = New SqlCommand();
SqlDataReader dr;
cmd.CommandText = "Select * From tableName Where ID = @ID"
cmd.Parameters.Add(New SqlParameter("@ID",SqlDbType.Int))
cmd.Parameters("@ID").Value = 28
dr = cmd.ExecuteReader()
SqlParameter[] 的使用方法
SqlParameter[] parameters = new SqlParameter[]
{
New SqlParameter("@productid",SqlDbType.Int, 4),
New SqlParameter("@itemName",SqlDbType.Varchar, 50 )
}
Parameters[0].Value = productCode;
Parameters[1].Value = DBNull.Value;