不能把输入到 txt_GYName 的字符 添加到数据库里面,请高手指教一下 谢谢private void button2_Click(object sender, System.EventArgs e)
{
TextBox txt_GYName = new TextBox();
leike = txt_GYName.Text;//全局变量
Button btn_TiJiao = new Button();
btn_TiJiao.Location = new Point(24, 56);
btn_TiJiao.Text = "提交";
btn_TiJiao.Click += new EventHandler(btn_TiJiao_Click); panel1.Controls.Add(btn_TiJiao);
panel1.Controls.Add(txt_GYName);
} private void btn_TiJiao_Click(object sender, EventArgs e)
{
string strConn = " Initial Catalog=gx;Data Source = LEIKE;User ID=sa;Password=sa";SqlConnection conn = new SqlConnection();
conn.ConnectionString = strConn;
try
{
SqlCommand inscmd = new SqlCommand();
inscmd.Connection = conn;
inscmd.CommandText = "INSERT INTO GuYuan (GYName) VALUES (@GYName)";
inscmd.Parameters.Add(new SqlParameter("@GYName",SqlDbType.NVarChar,50));
inscmd.Parameters["@GYName"].Value=leike;
conn.Open ();
inscmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception a)
{
MessageBox.Show (a.Message,"警告",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
}
}
}
{
TextBox txt_GYName = new TextBox();
leike = txt_GYName.Text;//全局变量
Button btn_TiJiao = new Button();
btn_TiJiao.Location = new Point(24, 56);
btn_TiJiao.Text = "提交";
btn_TiJiao.Click += new EventHandler(btn_TiJiao_Click); panel1.Controls.Add(btn_TiJiao);
panel1.Controls.Add(txt_GYName);
} private void btn_TiJiao_Click(object sender, EventArgs e)
{
string strConn = " Initial Catalog=gx;Data Source = LEIKE;User ID=sa;Password=sa";SqlConnection conn = new SqlConnection();
conn.ConnectionString = strConn;
try
{
SqlCommand inscmd = new SqlCommand();
inscmd.Connection = conn;
inscmd.CommandText = "INSERT INTO GuYuan (GYName) VALUES (@GYName)";
inscmd.Parameters.Add(new SqlParameter("@GYName",SqlDbType.NVarChar,50));
inscmd.Parameters["@GYName"].Value=leike;
conn.Open ();
inscmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception a)
{
MessageBox.Show (a.Message,"警告",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
}
}
}
leike = txt_GYName.Text;//全局变量
-------------
inscmd.Parameters.Add(new SqlParameter("@GYName",SqlDbType.NVarChar,50));
inscmd.Parameters["@GYName"].Value=leike;leike 不是==""?
-------------这样做leike =""
数据库是不是不允许为空?你可以在btn_TiJiao_Click里面得到txt_GYName.Text
但是不能把输入到txt_GYName.Text的值写进数据库,其实更本就没有获取到txt_GYName.Text具体怎么解决 请帮帮忙 谢谢