hi
i have a project and need help.anybody knows what must i do?
i have a page that give a patentid to any patient for giving service that is unique.every patient has some service and some paper.i have 2 table paper and givservice in sql.i want enter services that have the same patientid on giveservice table how must i do that?
here is my code:
private void insert_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "server=.;database=database;integrated security=true;";
SqlCommand com1 = new SqlCommand();
SqlCommand com2 = new SqlCommand();
SqlCommand com3 = new SqlCommand();
SqlCommand com4 = new SqlCommand();
SqlCommand com5=new SqlCommand();
com1.CommandText="DECLARE @papercode smallint";
com2.CommandText = " insert into paper(date,drcode,patientid,unitid,personid)values(@date,@drcode,@patientid,@unitid,'15')";
com5.CommandText = "SET @papercode=SCOPE_IDENTITY()";
com3.CommandText = " Select @papercode=papercode From patient,Paper Where patient.patientid=Paper.patientid";
com4.CommandText = "insert into givservice (papercode,price,tedad,khid) values ( @papercode,@price,@tedad,@khid)";
com1.Connection = con;
com2.Connection = con;
com3.Connection = con;
com4.Connection = con;
com1.Parameters.AddWithValue("@date", txtdate.Text);
com1.Parameters.AddWithValue("@patientid",txtpaziresh.Text);
com1.Parameters.AddWithValue("@unitid",cmdunitname.SelectedValue);
com1.Parameters.AddWithValue("@drcode", cmddrname.SelectedValue);
com4.Parameters.AddWithValue("@tedad", txttedad.Text);
com4.Parameters.AddWithValue("@price", cmdprice.SelectedValue);
com4.Parameters.AddWithValue("@khid", cmdkh.SelectedValue);
SqlParameter idOut = com5.Parameters.Add("@papercode", SqlDbType.SmallInt);
idOut.Direction = ParameterDirection.Output;
con.Open();
com1.ExecuteNonQuery();
SqlDataReader dr= com3.ExecuteReader();
con.Close();
}