数据库为什么不能插入数据?????很急。。
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\shujuku.mdf;Integrated Security=True;User Instance=True";
SqlConnection mycon = new SqlConnection(str);
string name = txtname.Text;
string age = txtage.Text;
SqlCommand mycom = new SqlCommand("insert into Table1 (Yname,Yage) values ('name','age')", mycon);
mycon.Open();
mycom.ExecuteNonQuery();
mycon.Close();
label3.Text = "添加数据库成功!";
}
能够运行,没有提示错误,但在数据库中没有插入数据,????