StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>you not excuting you cmd2, you must execute the insert Visit_Number in cmd2 then excute your cmd, you can test this code</p> <pre><code> using (con2) { con2.Open(); cmd2.ExecuteNonQuery(); } </code></pre> <p>then you can excute your cmd</p> <pre><code> using (con) { con.Open(); int count = cmd.ExecuteNonQuery(); } </code></pre> <p>and you can do the work with the same connexion if you want</p> <pre><code> string connect = System.Configuration.ConfigurationManager.ConnectionStrings["db_connection"].ToString(); SqlConnection con = new SqlConnection(connect); string visitnumber = txtVistNumber.Text.ToString(); string insert_statement = "Insert into Patient(Patient_Number,FirstName,LastName,Gender,Tribe,Date_Of_Birth,Visit_Number)" + "Values(@Patient_Number,@FirstName,@LastName,@Gender,@Tribe,@Date_Of_Birth,@Visit_Number)"; string insert_stament2 = "Insert into Visit(Visit_Number)" + "Values(@Visit_Number)"; using(con) { con.open; SqlCommand cmd2 = new SqlCommand(insert_stament2, con); cmd2.Parameters.AddWithValue("@Visit_Number", txtVistNumber.Text); cmd2.ExecuteNonQuery(); SqlCommand cmd = new SqlCommand(insert_statement, con); cmd.Parameters.AddWithValue("@Visit_Number", txtVistNumber.Text); cmd.Parameters.AddWithValue("@Patient_Number",txtpatientNum.Text); cmd.Parameters.AddWithValue("@FirstName",txtfirstName.Text); cmd.Parameters.AddWithValue("@LastName",txtlastname.Text); cmd.Parameters.AddWithValue("@Gender", drl_gender.SelectedValue); cmd.Parameters.AddWithValue("@Tribe",DropDownList1.Text); cmd.Parameters.AddWithValue("@Date_Of_Birth", val_age.Text); cmd.Parameters.AddWithValue("@Visit_Number", txtVistNumber.Text); cmd.ExecuteNonQuery(); } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload