Tama ba paggamit ko ng Using statement sa pagconnect sa database

[eidecedie17]

tama lang bang hindi nako mag con.close();?
saka ok lang ba kung hindi nako gumamit ng using sa SqlDataReader dr = cmd.ExecuteReader()?

using (SqlConnection con = new SqlConnection(connection.conString))
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT userName, pass FROM Users WHERE userName = @user COLLATE Latin1_General_CS_AS AND pass = @pass COLLATE Latin1_General_CS_AS", con);
cmd.Parameters.AddWithValue("@user", textBox1.Text);
cmd.Parameters.AddWithValue("@pass", textBox2.Text);

using (SqlDataReader dr = cmd.ExecuteReader())
{
try
{

if (dr.Read())
{

if (textBox1.Text == "admin")
{
this.Hide();
Main form = new Main();
form.Show();
}

else if (textBox1.Text == "voter")
{
this.Hide();
preVoting form = new preVoting();
form.Show();
}

}
else
{
MessageBox.Show("Invalid Username or Password", "", MessageBoxButtons.OK, MessageBoxIcon.Error);

}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}

saka tanong ko na din to guys, kasi kapag nageerror yung pag nagaadd ako tapos nagexecute ako ng Int32 getID = (Int32)cmd.ExecuteScalar(); tapos na catch yung error nya, pag nag add ako ulit ng tama na na value lumalaktaw na yung ID ko kunwari dapat 1 yung id pag nag add ako tapos nagerror sya, pag nag add nako ng walang error 2 na agad yung ID yung 1 na ID hindi na nagamit

eto yung code ko

using (SqlConnection con = new SqlConnection(connection.conString))
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO tblVoter (voterName, voterAdd, voterBday, voterGen, voterContact, voterEmail, dateReg, voted) output INSERTED.voterID VALUES(@name, @address, @bday, @gender, @contact, @email, @dateReg, @voted)", con);
cmd.Parameters.AddWithValue("@name", vLName.Text + ", " + vFName.Text + " " + vMName.Text);
cmd.Parameters.AddWithValue("@address", vAdd.Text);
cmd.Parameters.AddWithValue("@bday", vBday.Text);
cmd.Parameters.AddWithValue("@gender", vGen.Text);
cmd.Parameters.AddWithValue("@contact", vCont.Text);
cmd.Parameters.AddWithValue("@email", vEmail.Text);
cmd.Parameters.AddWithValue("@dateReg", DateTime.Now);
cmd.Parameters.AddWithValue("@voted", "0");
Int32 getID = (Int32)cmd.ExecuteScalar();
MessageBox.Show("Registration Successful", "", MessageBoxButtons.OK, MessageBoxIcon.Information);



ID = getID.ToString();
passvalue();
clear();
VoterPrint form = new VoterPrint();
form.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}

saka ok lang bang ang lagi kong ginagamit sqlcommand kaysa sqldataadapter?