T.Eftekhari
دوشنبه 06 آذر 1391, 14:15 عصر
با سلام تاپیکی برای سوال ها نیست که همه سوال هاشون بپرسن ؟
به هر حال
این کد منه
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication15
{
public partial class Form1 : Form
{
SqlConnection my_cn = new SqlConnection("server=(local);database=STUDENT;Integrated Security=True");
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
my_cn.Open();
}
private void button1_Click(object sender, EventArgs e)
{
if (radioButton1.Checked)
{
SqlCommand my_cm = new SqlCommand("insert into person (code_person,name,family,bed) values( '" + Int32.Parse(textBox1.Text) + "','" + textBox2.Text + "','" + textBox3.Text + "','" +Int32 .Parse ( textBox4.Text) + "'", my_cn);
my_cm.ExecuteNonQuery();
}
else
{
SqlCommand my_cm = new SqlCommand("insert into person (code_person,name,family,best) values( '" + Int32.Parse(textBox1.Text) + "','" + textBox2.Text + "','" + textBox3.Text + "','" + Int32.Parse(textBox4 .Text ) + "'", my_cn);
my_cm.ExecuteNonQuery();
}
my_cn.Close();
}
}
}
زمانی که اجرا می کنم
از قسمت nonquery
ارور Incorrect syntax near
می گیره مشکل کجاست ؟
به هر حال
این کد منه
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication15
{
public partial class Form1 : Form
{
SqlConnection my_cn = new SqlConnection("server=(local);database=STUDENT;Integrated Security=True");
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
my_cn.Open();
}
private void button1_Click(object sender, EventArgs e)
{
if (radioButton1.Checked)
{
SqlCommand my_cm = new SqlCommand("insert into person (code_person,name,family,bed) values( '" + Int32.Parse(textBox1.Text) + "','" + textBox2.Text + "','" + textBox3.Text + "','" +Int32 .Parse ( textBox4.Text) + "'", my_cn);
my_cm.ExecuteNonQuery();
}
else
{
SqlCommand my_cm = new SqlCommand("insert into person (code_person,name,family,best) values( '" + Int32.Parse(textBox1.Text) + "','" + textBox2.Text + "','" + textBox3.Text + "','" + Int32.Parse(textBox4 .Text ) + "'", my_cn);
my_cm.ExecuteNonQuery();
}
my_cn.Close();
}
}
}
زمانی که اجرا می کنم
از قسمت nonquery
ارور Incorrect syntax near
می گیره مشکل کجاست ؟