دوباره کد رو با sql به این شکل نوشتم خطا روی خط=cmd.ExecuteNonQuery
اینطوری شد:Line 1: Incorrect syntax near '-'.
using
System.Collections.Generic;
using
System.ComponentModel;
using
System.Data;
using
System.Drawing;
using
System.Text;
using
System.Windows.Forms;
using
System.Data.SqlClient;
namespace
sql
{
publicpartialclassForm1 : Form
{
SqlCommand cmd;
SqlConnection cnn;
SqlDataAdapter da;
DataSet dset;
public Form1()
{
InitializeComponent();
cnn =newSqlConnection();
cnn.ConnectionString = ("integrated security=SSPI;persist security info=True;initial catalog=me2");
}
privatevoid button1_Click(object sender, EventArgs e)
{;
SqlCommand cmd = newSqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "INSERT INTO my-t (first, last)" +
"VALUES(@first, @last)";
cmd.Parameters.AddWithValue("@last2", textBox1.Text);
cmd.Parameters.AddWithValue("@first2", textBox2.Text);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
}
}