ninja_boy
دوشنبه 28 اردیبهشت 1388, 17:33 عصر
با سلام
تابع mycommand.ExecuteNonQuery(); پیغام خطا می دهد
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace proje
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
int query;
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'database1DataSet.Table1' table. You can move, or remove it, as needed.
}
private void button2_Click(object sender, EventArgs e)
{
OleDbConnection myconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = .\\Database1.mdb");
string query = "('" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
DataSet mydataset = new DataSet();
myconnection.Open();
OleDbCommand mycommand = new OleDbCommand();
mycommand.CommandText = query;
mycommand.Connection = myconnection;
mycommand.ExecuteNonQuery();
mydataset.AcceptChanges();
myconnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection objconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = .\\Database1.mdb");
string query = "select * from Table1";
DataSet mydataset = new DataSet();
OleDbDataAdapter myadap = new OleDbDataAdapter(query, objconnection);
myadap.Fill(mydataset);
foreach (DataTable table in mydataset.Tables)
{
foreach (DataRow row in table.Rows)
{
if (textBox1.Text == row["name"].ToString())
dgv.Rows.Add(row["name"].ToString(), row["Phone"].ToString(), row["Address"].ToString(), row["Email"].ToString());
}
}
}
}
}
تابع mycommand.ExecuteNonQuery(); پیغام خطا می دهد
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace proje
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
int query;
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'database1DataSet.Table1' table. You can move, or remove it, as needed.
}
private void button2_Click(object sender, EventArgs e)
{
OleDbConnection myconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = .\\Database1.mdb");
string query = "('" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
DataSet mydataset = new DataSet();
myconnection.Open();
OleDbCommand mycommand = new OleDbCommand();
mycommand.CommandText = query;
mycommand.Connection = myconnection;
mycommand.ExecuteNonQuery();
mydataset.AcceptChanges();
myconnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection objconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = .\\Database1.mdb");
string query = "select * from Table1";
DataSet mydataset = new DataSet();
OleDbDataAdapter myadap = new OleDbDataAdapter(query, objconnection);
myadap.Fill(mydataset);
foreach (DataTable table in mydataset.Tables)
{
foreach (DataRow row in table.Rows)
{
if (textBox1.Text == row["name"].ToString())
dgv.Rows.Add(row["name"].ToString(), row["Phone"].ToString(), row["Address"].ToString(), row["Email"].ToString());
}
}
}
}
}