Maryam80
چهارشنبه 24 اسفند 1384, 12:42 عصر
با سلام
من یک Stored Procedure برای عمل INSERT نوشته ام که پس از عمل ثبت می خواهم مقدار کلید اصلی را بعنوان خروجی ارسال کند ولیکن نمی دانم که به چه صورت می توان خروجی SP را درون یک متغیر در برنامه ریخت
SqlCommand1.CommandText = "INSERT TBL_Client(CLIENTNAME,GROUPID,CLIENTPARENTID,SHORT NAME,STRUCTUREID,VER,WHO,DELTAG,EDITTAG,CustomerID ,ContractID) VALUES('" & TxtClient.Text & "'," & CmbGroup.SelectedValue & "," & SelectedParentID & ",'" & TxtShortname.Text & "'," & CmbGroupStructure.SelectedValue & ",1," & KeepUserId & "," & deltag & ",0," & CmbCustomer.SelectedValue & "," & CmbContract.SelectedValue & ")"
SqlCommand1.CommandType = CommandType.StoredProcedure
SqlCommand1.CommandText = "exec Insert_Tbl_Client '" & TxtClient.Text & "'," & CmbGroup.SelectedValue & "," & SelectedParentID & ",'" & TxtShortname.Text & "'," & CmbGroupStructure.SelectedValue & ",1," & KeepUserId & "," & deltag & ",0," & CmbCustomer.SelectedValue & "," & CmbContract.SelectedValue & "," & ClientIDentity
SqlCommand1.Parameters.Add("@clientid", ClientIDentity)
SqlCommand1.Parameters("@clientid").Direction = ParameterDirection.ReturnValue
SqlCommand1.Parameters("@clientid").Value = "null"
SqlCommand1.Connection.Open()
ClientIDentity = SqlCommand1.ExecuteScalar
SqlCommand1.Connection.close()
من یک Stored Procedure برای عمل INSERT نوشته ام که پس از عمل ثبت می خواهم مقدار کلید اصلی را بعنوان خروجی ارسال کند ولیکن نمی دانم که به چه صورت می توان خروجی SP را درون یک متغیر در برنامه ریخت
SqlCommand1.CommandText = "INSERT TBL_Client(CLIENTNAME,GROUPID,CLIENTPARENTID,SHORT NAME,STRUCTUREID,VER,WHO,DELTAG,EDITTAG,CustomerID ,ContractID) VALUES('" & TxtClient.Text & "'," & CmbGroup.SelectedValue & "," & SelectedParentID & ",'" & TxtShortname.Text & "'," & CmbGroupStructure.SelectedValue & ",1," & KeepUserId & "," & deltag & ",0," & CmbCustomer.SelectedValue & "," & CmbContract.SelectedValue & ")"
SqlCommand1.CommandType = CommandType.StoredProcedure
SqlCommand1.CommandText = "exec Insert_Tbl_Client '" & TxtClient.Text & "'," & CmbGroup.SelectedValue & "," & SelectedParentID & ",'" & TxtShortname.Text & "'," & CmbGroupStructure.SelectedValue & ",1," & KeepUserId & "," & deltag & ",0," & CmbCustomer.SelectedValue & "," & CmbContract.SelectedValue & "," & ClientIDentity
SqlCommand1.Parameters.Add("@clientid", ClientIDentity)
SqlCommand1.Parameters("@clientid").Direction = ParameterDirection.ReturnValue
SqlCommand1.Parameters("@clientid").Value = "null"
SqlCommand1.Connection.Open()
ClientIDentity = SqlCommand1.ExecuteScalar
SqlCommand1.Connection.close()