private void button1_Click(object sender, System.EventArgs e)
{
string string1=textBox1.Text;
string string2=textBox2.Text;
int num=System.Convert.ToInt32(textBox3.Text);
string mystring="integrated security=SSPI;data source=YY;persist security info=False;initial catalog=Sports;";
SqlConnection myconnection=new SqlConnection(mystring);
myconnection.Open();
string quarystring="INSERT INTO 项目表(ITEM,SEX,NUM) Values('string1','string2','num')";
SqlCommand mycommand=new SqlCommand(quarystring,myconnection);
myconnection.Close();

}
运行程序以后数据库里没有插入的数据记录，请问是怎么回事啊？

private void button1_Click(object sender, System.EventArgs e)
{
string string1=textBox1.Text;
string string2=textBox2.Text;
int num=System.Convert.ToInt32(textBox3.Text);
string mystring="integrated security=SSPI;data source=YY;persist security info=False;initial catalog=Sports;";
SqlConnection myconnection=new SqlConnection(mystring);
myconnection.Open();
string quarystring="insert into 项目表(item,sex,num) values('"+string1+"','"+string2+"',"+num+")";
SqlCommand mycommand=new SqlCommand(quarystring,myconnection);
mycommand.ExecuteNonQuery();
myconnection.Close();

}

[此贴子已经被作者于2006-4-23 9:14:40编辑过]