插入两个带有检查条件的表 [英] insert in two table with check condition

问题描述

嗨 我有一个项目，需要帮助.有人知道我该怎么办?
我有一个页面可以为任何患者提供唯一的专利服务，每个患者都有某种服务和一些paper.i在sql中有2张表纸和givservice.我想在Giveservice表上输入具有相同Patientid的服务我必须这样做吗?
这是我的代码:

 私有  void  insert_Click(对象发​​件人，EventArgs e)

        {


            SqlConnection con = 新 SqlConnection();
            con.ConnectionString = " ;
            SqlCommand com1 = 新 SqlCommand();
            SqlCommand com2 = 新 SqlCommand();
            SqlCommand com3 = 新 SqlCommand();
            SqlCommand com4 = 新 SqlCommand();
            SqlCommand com5 = 新 SqlCommand();
            com1.CommandText = " ;
            com2.CommandText = " ;
            com5.CommandText = " ;
            com3.CommandText = " ;
            com4.CommandText = " ;
            com1.Connection = con;
            com2.Connection = con;
            com3.Connection = con;
             com4.Connection = con;
            com1.Parameters.AddWithValue(" ，txtdate.Text);
            com1.Parameters.AddWithValue(" ，txtpaziresh.Text);
             com1.Parameters.AddWithValue(" ，cmdunitname.SelectedValue);
             com1.Parameters.AddWithValue(" ，cmddrname.SelectedValue);
            com4.Parameters.AddWithValue(" ，txttedad.Text)；
            com4.Parameters.AddWithValue(" ，cmdprice.SelectedValue);
            com4.Parameters.AddWithValue(" ，cmdkh.SelectedValue);
            SqlParameter idOut = com5.Parameters.Add(" ，SqlDbType.SmallInt);
            idOut.Direction = ParameterDirection.Output;
            con.Open();
            com1.ExecuteNonQuery();
            SqlDataReader dr = com3.ExecuteReader();
            con.Close();
} 

解决方案

正在使用什么版本的SQL yoiu.如果其2005或更高版本，则可以使用带有输出子句的insert语句.
以下链接为您提供了有关该链接的详细信息.

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

希望对您有所帮助.

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();
}

解决方案

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.

这篇关于插入两个带有检查条件的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！