c#编写winform在win7 64位下没问题的代码在xp系统运行没反应
详细看我的注释把应该卡在插入数据语句上了别的地方都在别的按钮运行了没有问题privatevoidbutton1_Click_2(objectsender,EventArg...
详细看我的注释把 应该卡在插入数据语句上了 别的地方都在别的按钮运行了 没有问题
private void button1_Click_2(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "" || comboBox1.Text == "" || textBox3.Text == "")
{
MessageBox.Show("姓名、年龄、性别、电话不能为空");//这里也提示 没有问题
}
else
{
SqlConnection myCon = new SqlConnection();
myCon.ConnectionString = Form1.datacon;//数据库字符串变量 !!这里没有问题别的按钮好使
try//异常处理
{
myCon.Open();
SqlCommand sqlcmd = new SqlCommand(); //应该卡在这里了 数据库用的sql2005
string cmdText = "insert into huanzhe(name,age,sex,tel,keshi,firstday,shenfen,dizhi,leixing,bingshi,pic)values('" + Convert.ToString(textBox1.Text) + "','" + Convert.ToString(textBox2.Text) + "','" + Convert.ToString(comboBox1.Text) + "','" + Convert.ToString(textBox3.Text) + "','" + Convert.ToString(comboBox2.Text) + "','" + Convert.ToString(dateTimePicker1.Value.ToString()) + "','" + Convert.ToString(textBox4.Text) + "','" + Convert.ToString(richTextBox1.Text) + "','" + Convert.ToString(comboBox3.Text) + "','" + Convert.ToString(comboBox4.Text) + "','" + pic + "')";
sqlcmd.Connection = myCon;
sqlcmd.CommandText = cmdText;
//sqlcmd.ExecuteNonQuery();
int val = sqlcmd.ExecuteNonQuery();//设置判断执行成功与否的变量
if (val >= 1)
{
MessageBox.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("请正确输入!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
myCon.Close();
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex);
}
}
} 展开
private void button1_Click_2(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "" || comboBox1.Text == "" || textBox3.Text == "")
{
MessageBox.Show("姓名、年龄、性别、电话不能为空");//这里也提示 没有问题
}
else
{
SqlConnection myCon = new SqlConnection();
myCon.ConnectionString = Form1.datacon;//数据库字符串变量 !!这里没有问题别的按钮好使
try//异常处理
{
myCon.Open();
SqlCommand sqlcmd = new SqlCommand(); //应该卡在这里了 数据库用的sql2005
string cmdText = "insert into huanzhe(name,age,sex,tel,keshi,firstday,shenfen,dizhi,leixing,bingshi,pic)values('" + Convert.ToString(textBox1.Text) + "','" + Convert.ToString(textBox2.Text) + "','" + Convert.ToString(comboBox1.Text) + "','" + Convert.ToString(textBox3.Text) + "','" + Convert.ToString(comboBox2.Text) + "','" + Convert.ToString(dateTimePicker1.Value.ToString()) + "','" + Convert.ToString(textBox4.Text) + "','" + Convert.ToString(richTextBox1.Text) + "','" + Convert.ToString(comboBox3.Text) + "','" + Convert.ToString(comboBox4.Text) + "','" + pic + "')";
sqlcmd.Connection = myCon;
sqlcmd.CommandText = cmdText;
//sqlcmd.ExecuteNonQuery();
int val = sqlcmd.ExecuteNonQuery();//设置判断执行成功与否的变量
if (val >= 1)
{
MessageBox.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("请正确输入!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
myCon.Close();
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex);
}
}
} 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询