想要在数据源可变时从3表中插入值 [英] Want to insert value in 3 table from when data source is variable

问题描述

我的商店程序： -

  ALTER   PROCEDURE  [dbo]。[tblScriptInsert] 
   -   添加此处存储过程的参数 
  @ ScriptId   int  
  AS  
  BEGIN  
   -  添加SET NOCOUNT ON以防止额外的结果集 
   -   干扰SELECT语句。 
  SET   NOCOUNT   ON ; 
 
   -   在此处插入程序语句 
  INSERT   INTO  [dbo]。[tblScript]（[ScriptId]）
  SELECT   @ ScriptId  
  INSERT   INTO  [dbo]。[tbl_clientcolumnnames]（[ScriptId]）
  SELECT   @ ScriptId  
  INSERT   INTO  [dbo]。[tbl_Intellectcolumnnames]（[ScriptId] ）
  SELECT   @ ScriptId  
 结束 

我的c＃代码，但没有插入任何东西和nooo错误请帮助我们，如果我的代码中的任何错误请告诉我。

 globalScriptid = ScriptId.ToString（）; 
 SqlCommand cmd4 =  new  SqlCommand（  tblScriptInsert ，连接）; 
 cmd4.Parameters.Add（  @ScriptId，SqlDbType.Int）.Value = globalScriptid.ToString（）; 
 cmd4.CommandType = CommandType.StoredProcedure; 
 

解决方案

插入表（column_name）值（@ScriptId）

嗨Hareesh



i我在存储过程中做了更改但是数据没有插入

 globalScriptid = ScriptId.ToString（）; 
 SqlParameter参数=  null ; 
 SqlCommand cmd4 =  new  SqlCommand（  tblScriptInsert ，连接）; 
 cmd4.CommandType = CommandType.StoredProcedure; 
 cmd4.Parameters.Add（ new  SqlParameter（  @ScriptId，SqlDbType.Int））。Value = globalScriptid.ToString（）; 
 cmd4.Parameters.Add（参数）; 
 cmd4.ExecuteNonQuery（）; 

i完成此更改已知数据插入3表感谢您所有宝贵的时间

My store Procedure :-

ALTER PROCEDURE [dbo].[tblScriptInsert]
	-- Add the parameters for the stored procedure here
	 @ScriptId int 
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	 INSERT INTO [dbo].[tblScript] ([ScriptId])
       SELECT @ScriptId
       INSERT INTO [dbo].[tbl_clientcolumnnames] ([ScriptId])
       SELECT @ScriptId
       INSERT INTO [dbo].[tbl_Intellectcolumnnames] ([ScriptId])
       SELECT @ScriptId
END

My c# code but not insert any thing and nooo error pls help us if any thing wrong in my code pls let me know.

globalScriptid = ScriptId.ToString();
                   SqlCommand cmd4 = new SqlCommand("tblScriptInsert", connection);
                   cmd4.Parameters.Add(" @ScriptId", SqlDbType.Int).Value = globalScriptid.ToString();
                   cmd4.CommandType = CommandType.StoredProcedure;

解决方案

insert into table(column_name) values(@ScriptId)

Hi Hareesh

i am done change in stored procedure but still data not inset

globalScriptid = ScriptId.ToString();
                    SqlParameter parameter = null;
                    SqlCommand cmd4 = new SqlCommand("tblScriptInsert", connection);
                    cmd4.CommandType = CommandType.StoredProcedure;
                    cmd4.Parameters.Add(new SqlParameter ("@ScriptId", SqlDbType.Int)).Value = globalScriptid.ToString();
                    cmd4.Parameters.Add(parameter);
                    cmd4.ExecuteNonQuery();

i am done this changed know data insert in 3 table thank you to all your valuable time

这篇关于想要在数据源可变时从3表中插入值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！