foreach (ListItem item in CheckBoxList2.Items) { cmd = new SqlCommand("SP_Insert_Form", cnc); cmd.Parameters.AddWithValue("@Name", TxtName.Text); cmd.Parameters.AddWithValue("@Family", TxtFamily.Text); cmd.Parameters.AddWithValue("@CodMeli", TxtCodmeli.Text); cmd.Parameters.AddWithValue("@FathersName", TxtFather.Text); cmd.Parameters.AddWithValue("@Birthday", TxtDate.Text); cmd.Parameters.AddWithValue("@Age_ID", DrpAeg.SelectedValue); cmd.Parameters.AddWithValue("@Institute_ID", DrpInstitute.SelectedValue); cmd.Parameters.AddWithValue("@Mobile", TxtMobil.Text); cmd.Parameters.AddWithValue("@Date", Session["Date"]); cmd.Parameters.AddWithValue("@Random", m); cmd.Parameters.AddWithValue("@Reshte_ID", item.Value); cmd.CommandType = System.Data.CommandType.StoredProcedure; danger.Visible = false; success.Visible = true; cmd.ExecuteNonQuery(); }
این هم پروسیجرم
ALTER PROCEDURE [dbo].[SP_Insert_Form] @Name nvarchar(50), @Family nvarchar(50) , @CodMeli char(10), @FathersName nvarchar(50) , @Birthday char(4) , @Age_ID int , @Reshte_ID int , @Mobile char(11), @Institute_ID int, @Date char(10), @Random int as declare @F_id int begin insert into Table_Form_Sabtname(Name,Family,CodMeli,FathersNam e,Birthday,Age_ID,Mobile,Institute_ID,Date,Random) values(@Name,@Family,@CodMeli,@FathersName,@Birthd ay,@Age_ID,@Mobile,@Institute_ID,@Date, @Random) select @F_id=@@IDENTITY from Table_Form_Sabtname insert into Table_Relation (Reshte_ID,F_id)values (@Reshte_ID,@F_id) end