saeed-71
پنج شنبه 23 آذر 1391, 10:22 صبح
سلام.
مشکل این کد و برنامه تو قسمت ویرایش اطلاعات چیه؟واینکه این کد معنیش چیه؟
this.Form1_Load(sender, e);
برنامه رو پیوست کردم.
اینم کد برنامه.دیتا بیس من اکسس هستش.
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.OleDb;
using System.Collections;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
OleDbConnection cnn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DB.accdb");
OleDbDataAdapter sda;// = new OleDbDataAdapter();
OleDbCommand cmd;// = new OleDbCommand();
DataSet ds;// = new DataSet();
ArrayList arr;// = new ArrayList();
private void connect()
{
//cnn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DB.accdb";
}
public Form1()
{
InitializeComponent();
}
private DataSet LoadAll()
{
cmd = new OleDbCommand();
cmd.CommandText = "select * from TBL ";
cmd.Connection = cnn;
sda = new OleDbDataAdapter();
ds = new DataSet();
sda.SelectCommand = cmd;
cnn.Open();
sda.Fill(ds, "TBL");
cnn.Close();
return ds;
}
private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = LoadAll();
dataGridView1.DataMember = "TBL";
dataGridView1.AutoGenerateColumns = true;
}
private void Insert (OleDbCommand cmd)
{
//connect();
cnn.Close();
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
arr = new ArrayList();
arr.Add(textBox1.Text);
arr.Add(textBox2.Text);
cmd.CommandText = "insert into TBL (name,tell)values(@value1,@value2)";
cmd.Parameters.Clear();
cmd.Parameters.Add("@value1", OleDbType.VarChar).Value = arr[0].ToString();
cmd.Parameters.Add("@value2", OleDbType.VarChar).Value = arr[1].ToString();
Insert(cmd);
this.Form1_Load(sender, e);
//dataGridView1.DataSource = ds;
//dataGridView1.DataMember = "TBL";
//dataGridView1.DataMember
}
private void Delete(OleDbCommand cmd)
{
//connect();
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
private void button3_Click(object sender, EventArgs e)
{
arr.Add(textBox1.Text);
arr.Add(textBox2.Text);
cmd.CommandText = "Delete from TBL where ID=@ID";
cmd.Parameters.Clear();
cmd.Parameters.Add("ID", OleDbType.Integer).Value = int.Parse(arr[0].ToString());
Delete(cmd);
LoadAll();
this.Form1_Load(sender, e);
}
}
}
مشکل این کد و برنامه تو قسمت ویرایش اطلاعات چیه؟واینکه این کد معنیش چیه؟
this.Form1_Load(sender, e);
برنامه رو پیوست کردم.
اینم کد برنامه.دیتا بیس من اکسس هستش.
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.OleDb;
using System.Collections;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
OleDbConnection cnn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DB.accdb");
OleDbDataAdapter sda;// = new OleDbDataAdapter();
OleDbCommand cmd;// = new OleDbCommand();
DataSet ds;// = new DataSet();
ArrayList arr;// = new ArrayList();
private void connect()
{
//cnn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DB.accdb";
}
public Form1()
{
InitializeComponent();
}
private DataSet LoadAll()
{
cmd = new OleDbCommand();
cmd.CommandText = "select * from TBL ";
cmd.Connection = cnn;
sda = new OleDbDataAdapter();
ds = new DataSet();
sda.SelectCommand = cmd;
cnn.Open();
sda.Fill(ds, "TBL");
cnn.Close();
return ds;
}
private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = LoadAll();
dataGridView1.DataMember = "TBL";
dataGridView1.AutoGenerateColumns = true;
}
private void Insert (OleDbCommand cmd)
{
//connect();
cnn.Close();
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
arr = new ArrayList();
arr.Add(textBox1.Text);
arr.Add(textBox2.Text);
cmd.CommandText = "insert into TBL (name,tell)values(@value1,@value2)";
cmd.Parameters.Clear();
cmd.Parameters.Add("@value1", OleDbType.VarChar).Value = arr[0].ToString();
cmd.Parameters.Add("@value2", OleDbType.VarChar).Value = arr[1].ToString();
Insert(cmd);
this.Form1_Load(sender, e);
//dataGridView1.DataSource = ds;
//dataGridView1.DataMember = "TBL";
//dataGridView1.DataMember
}
private void Delete(OleDbCommand cmd)
{
//connect();
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
private void button3_Click(object sender, EventArgs e)
{
arr.Add(textBox1.Text);
arr.Add(textBox2.Text);
cmd.CommandText = "Delete from TBL where ID=@ID";
cmd.Parameters.Clear();
cmd.Parameters.Add("ID", OleDbType.Integer).Value = int.Parse(arr[0].ToString());
Delete(cmd);
LoadAll();
this.Form1_Load(sender, e);
}
}
}