پیام حیاتی
شنبه 25 آذر 1391, 11:46 صبح
سلام
من یک دیتابیس به نام DCollege و یک جدول به نام TCollege ساختم ، فرم Visual بدین شکل هست :
http://ahvazsell.com/Test/DB-Error-1.png
زمانی که اطلاعات رو در TextBox ها وارد می کنم و کلید Insert رو میزنم با خطای :
No overload for method 'EndExecuteNonQuery' takes 0 arguments
مواجه میشم.
به این دستور خطا میده :
com1.EndExecuteNonQuery();
این کدهای دکمه Insert من هست :
private void button2_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection("Integrated Security=true;Initial Catalog=DCollage");
con1.Open();
String strQuery = String.Format("INSERT INTO TCollege VALUES ('{0}','{1}','{2}')", textBox2.Text, textBox3.Text);
SqlCommand com1 = new SqlCommand(strQuery, con1);
com1.EndExecuteNonQuery();
con1.Close();
load_database();
}
این هم کل کدها :
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;
using System.Data.SqlClient;
namespace DataBase
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void load_database()
{
SqlConnection con1 = new SqlConnection("Integrated Security=TRUE;Initial Catallog=DCollege");
con1.Open();
SqlDataAdapter da1 = new SqlDataAdapter("SELECT * FROM TCollege", con1);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "TEMP");
dataGridView1.DataSource = ds1;
dataGridView1.DataMember = "TEMP";
con1.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dCollegeDataSet.TCollege' table. You can move, or remove it, as needed.
this.tCollegeTableAdapter.Fill(this.dCollegeDataSe t.TCollege);
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection("Integrated Security=TRUE;Initial Catalog=DCollege");
con1.Open();
String strQuery = "DELETE FROM TCollege WHERE STno ='" + textBox1.Text + "'";
SqlCommand com1 = new SqlCommand(strQuery, con1);
com1.ExecuteNonQuery();
con1.Close();
load_database();
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection("Integrated Security=true;Initial Catalog=DCollage");
con1.Open();
String strQuery = String.Format("INSERT INTO TCollege VALUES ('{0}','{1}','{2}')", textBox2.Text, textBox3.Text);
SqlCommand com1 = new SqlCommand(strQuery, con1);
com1.EndExecuteNonQuery();
con1.Close();
load_database();
}
}
}
من یک دیتابیس به نام DCollege و یک جدول به نام TCollege ساختم ، فرم Visual بدین شکل هست :
http://ahvazsell.com/Test/DB-Error-1.png
زمانی که اطلاعات رو در TextBox ها وارد می کنم و کلید Insert رو میزنم با خطای :
No overload for method 'EndExecuteNonQuery' takes 0 arguments
مواجه میشم.
به این دستور خطا میده :
com1.EndExecuteNonQuery();
این کدهای دکمه Insert من هست :
private void button2_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection("Integrated Security=true;Initial Catalog=DCollage");
con1.Open();
String strQuery = String.Format("INSERT INTO TCollege VALUES ('{0}','{1}','{2}')", textBox2.Text, textBox3.Text);
SqlCommand com1 = new SqlCommand(strQuery, con1);
com1.EndExecuteNonQuery();
con1.Close();
load_database();
}
این هم کل کدها :
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;
using System.Data.SqlClient;
namespace DataBase
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void load_database()
{
SqlConnection con1 = new SqlConnection("Integrated Security=TRUE;Initial Catallog=DCollege");
con1.Open();
SqlDataAdapter da1 = new SqlDataAdapter("SELECT * FROM TCollege", con1);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "TEMP");
dataGridView1.DataSource = ds1;
dataGridView1.DataMember = "TEMP";
con1.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dCollegeDataSet.TCollege' table. You can move, or remove it, as needed.
this.tCollegeTableAdapter.Fill(this.dCollegeDataSe t.TCollege);
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection("Integrated Security=TRUE;Initial Catalog=DCollege");
con1.Open();
String strQuery = "DELETE FROM TCollege WHERE STno ='" + textBox1.Text + "'";
SqlCommand com1 = new SqlCommand(strQuery, con1);
com1.ExecuteNonQuery();
con1.Close();
load_database();
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection("Integrated Security=true;Initial Catalog=DCollage");
con1.Open();
String strQuery = String.Format("INSERT INTO TCollege VALUES ('{0}','{1}','{2}')", textBox2.Text, textBox3.Text);
SqlCommand com1 = new SqlCommand(strQuery, con1);
com1.EndExecuteNonQuery();
con1.Close();
load_database();
}
}
}