Database access with stored procedure and parameters
string connectionString = Settings.Default.DynamicsConnectionString;
using (connectionString)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = connection;
cmd.Parameters.Add("@division",SqlDbType.NVarChar).Value = DDLDivision.SelectedValue;
cmd.Parameters.Add("@line", SqlDbType.Int).Value = DDLLine.SelectedValue;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_GetTankNumber";
SqlDataReader reader = null;
try
{
connection.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
DDLTank.Items.Add(reader["TankNumber"].ToString());
}
}
catch (SqlException)
{
}
catch (Exception ex)
{
}
finally
{
connection.Close();
cmd.Dispose();
connection.Dispose();
}
}
}