UC知道C# 数据库简简单单的问题
来源：百度知道 编辑：UC知道 时间：2024/05/17 09:17:40
存储过程是这样
CREATE PROCEDURE Teac_Into
@name varchar
AS
insert into teacher_info_north(teacher_id,teacher_num,comp_num,tea_name,tea_password,set_id) select * from Temp_Tn where tea_name=@name
GO
调用过程是这样：
SqlConnection conn = new SqlConnection
(System.Configuration.ConfigurationManager.AppSettings["sqlConnString"]);
SqlCommand com = new SqlCommand("Teac_Into", conn);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@name", txt_name.Text);
conn.Open();
com.ExecuteNonQuery();
整个过程有问题吗？代码在程序中没调用，怎么回事啊？谢谢大家了
CREATE PROCEDURE Teac_Into
@name varchar
AS
insert into teacher_info_north(teacher_id,teacher_num,comp_num,tea_name,tea_password,set_id) select * from Temp_Tn where tea_name=@name
GO
调用过程是这样：
SqlConnection conn = new SqlConnection
(System.Configuration.ConfigurationManager.AppSettings["sqlConnString"]);
SqlCommand com = new SqlCommand("Teac_Into", conn);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@name", txt_name.Text);
conn.Open();
com.ExecuteNonQuery();
整个过程有问题吗？代码在程序中没调用，怎么回事啊？谢谢大家了
没有将(System.Configuration.ConfigurationManager.AppSettings["sqlConnString"]); 加到conn中。虽然程序运行没错误，因为SqlCommand com = new SqlCommand("Teac_Into", conn);
有用到这个变量，你用单步执行一下，conn是空的即为Null。
没有问题,可能是没有查询到符合 txt_name.Text 的值