代码如下,问题在代码后
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Common;
using System.Configuration;
namespace sqlconnection
{
public partial class Form1 : Form
{
SqlConnection con = new SqlConnection("server=.\sqlexpress;integrated security=true;database=master;");
SqlCommand cmd;
SqlDataReader sqldr;
public Form1()
{
InitializeComponent();
con.Open();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
cmd = new SqlCommand("SELECT*FROM [table1]", con);
sqldr = cmd.ExecuteReader();
label1.Text = "";
while (sqldr.Read())
{
label1.Text = label1.Text + String.Format("{0}{1}{2}", sqldr[0], sqldr[1],sqldr[2]);
}
}
catch (Exception ex)
{
label1.Text = ex.Message;
}
}
private void button2_Click(object sender, EventArgs e)
{
SqlCommand cmd_add = new SqlCommand("",con);
cmd_add.CommandText = "insret into [table1](序号,名称,型号,原价,售价) values(@序号,@名称,@型号,@原价,@售价)";
cmd_add.Parameters.AddWithValue("@序号", "3");
cmd_add.Parameters.AddWithValue("@名称", "pc主机");
cmd_add.Parameters.AddWithValue("@型号", "del9898");
cmd_add.Parameters.AddWithValue("@原价", "3300");
cmd_add.Parameters.AddWithValue("@售价", "3500");
int ret = cmd_add.ExecuteNonQuery();
label2.Text = "add successfull";
}
}
}
这是两个按钮和两个label,button1能把我数据库table1中的信息查出来,但是button2按了就是显示说into附近有语法错误