Click here to Skip to main content
15,938,682 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:

C#
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();
}
Posted
Updated 11-Oct-11 21:28pm
v3

1 solution

What version of SQL yoiu are using. If its 2005 or above then you can use insert statement with output clause.
Following link gives you detail about the same.

http://technet.microsoft.com/en-us/library/ms177564.aspx[^]

Hope it helps.
 
Share this answer
 
Comments
sara2020 12-Oct-11 3:30am    
i work sqlserver 2008r2 but i dont recieve my reply .please help more.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900