小弟
有一事不名,请各位大侠多多指点。谢谢啊!!!!
我想用在C#中向数据库中添加数据,我的思路是;建表(information)和存储过程(cunc),在存储过程中我写的是
@name nchar(10)
as
insert into information (name) values (@name)
在button_click中我写到
string a=textbox1.text.trim();
string connString = Properties.Settings.Default.MyDatabaseConnectionString;
SqlConnection conn = new SqlConnection(connString);
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandText = "cunc";
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Connection = conn;
conn.Open();
SqlParameter Pxingming= new SqlParameter("@name", SqlDbType.NChar,10);
Pxingming.Value =a ;
sqlcmd.Parameters.Add(Pxingming)
try
{
sqlcmd.ExecuteScalar().ToString();
messagebox.shoe("添加成功!");
}
catch(Exception err)
{
messagebox.show(err.Message," 出错!!");
}
finally
{
conn.Close();
}
大侠们!
我想问为什么添加不成功!!到数据库中看时没有添加内容!!
有一事不名,请各位大侠多多指点。谢谢啊!!!!
我想用在C#中向数据库中添加数据,我的思路是;建表(information)和存储过程(cunc),在存储过程中我写的是
@name nchar(10)
as
insert into information (name) values (@name)
在button_click中我写到
string a=textbox1.text.trim();
string connString = Properties.Settings.Default.MyDatabaseConnectionString;
SqlConnection conn = new SqlConnection(connString);
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandText = "cunc";
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Connection = conn;
conn.Open();
SqlParameter Pxingming= new SqlParameter("@name", SqlDbType.NChar,10);
Pxingming.Value =a ;
sqlcmd.Parameters.Add(Pxingming)
try
{
sqlcmd.ExecuteScalar().ToString();
messagebox.shoe("添加成功!");
}
catch(Exception err)
{
messagebox.show(err.Message," 出错!!");
}
finally
{
conn.Close();
}
大侠们!
我想问为什么添加不成功!!到数据库中看时没有添加内容!!