metallica
دوشنبه 23 خرداد 1390, 10:23 صبح
با سلام
کد زیر مال فرم delete من هست که یک سطر انتخاب شده رو حذف میکنه.
public partial class Delete : Form
{ string strCon,strSql;
DataSet ds=new DataSet();
OleDbConnection Con=new OleDbConnection();
OleDbDataAdapter da=new OleDbDataAdapter();
OleDbCommandBuilder cb=new OleDbCommandBuilder();
string selectedRow;
public Delete()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=DBA.mdb";
Con = new OleDbConnection(strCon);
Con.Open();
strSql = "Delete From DBA Where ID=" + "" + selectedRow + "";
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "DBA");
ds.Clear();
MessageBox.Show("ِdeleted");
// TODO: This line of code loads data into the 'dBADataSet.DBA' table. You can move, or remove it, as needed.
this.dBATableAdapter.Fill(this.dBADataSet.DBA);
// TODO: This line of code loads data into the 'dBADataSet.tableGrop' table. You can move, or remove it, as needed.
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=DBA.mdb";
strSql = "Select*from DBA";
Con = new OleDbConnection(strCon);
Con.Open();
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "DBA");
}
private void Delete_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dBADataSet.DBA' table. You can move, or remove it, as needed.
this.dBATableAdapter.Fill(this.dBADataSet.DBA);
// TODO: This line of code loads data into the 'dBADataSet.tableGrop' table. You can move, or remove it, as needed.
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=DBA.mdb";
strSql = "Select*from DBA";
Con = new OleDbConnection(strCon);
Con.Open();
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "DBA");
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
selectedRow=dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
selectedRow = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
}
میخوام چند سطر و انتخاب کنم و با زدن delete اون چند سطر حذف بشن!
کسی میتونه کمکم کنه؟!
کد زیر مال فرم delete من هست که یک سطر انتخاب شده رو حذف میکنه.
public partial class Delete : Form
{ string strCon,strSql;
DataSet ds=new DataSet();
OleDbConnection Con=new OleDbConnection();
OleDbDataAdapter da=new OleDbDataAdapter();
OleDbCommandBuilder cb=new OleDbCommandBuilder();
string selectedRow;
public Delete()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=DBA.mdb";
Con = new OleDbConnection(strCon);
Con.Open();
strSql = "Delete From DBA Where ID=" + "" + selectedRow + "";
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "DBA");
ds.Clear();
MessageBox.Show("ِdeleted");
// TODO: This line of code loads data into the 'dBADataSet.DBA' table. You can move, or remove it, as needed.
this.dBATableAdapter.Fill(this.dBADataSet.DBA);
// TODO: This line of code loads data into the 'dBADataSet.tableGrop' table. You can move, or remove it, as needed.
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=DBA.mdb";
strSql = "Select*from DBA";
Con = new OleDbConnection(strCon);
Con.Open();
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "DBA");
}
private void Delete_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dBADataSet.DBA' table. You can move, or remove it, as needed.
this.dBATableAdapter.Fill(this.dBADataSet.DBA);
// TODO: This line of code loads data into the 'dBADataSet.tableGrop' table. You can move, or remove it, as needed.
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=DBA.mdb";
strSql = "Select*from DBA";
Con = new OleDbConnection(strCon);
Con.Open();
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "DBA");
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
selectedRow=dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
selectedRow = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
}
میخوام چند سطر و انتخاب کنم و با زدن delete اون چند سطر حذف بشن!
کسی میتونه کمکم کنه؟!