大家看这图...1.当点dataGridView最后一行时,就会出现一新行可以输入数据,我想当点一button时,把这添加的一行存到数据库,怎么保存这添加的一行的数据?
2.当点有数据的一行时可以修改数据,如何点一button,把这修改的数据传回到数据库?
3.如果在dataGridView上面执行删除操作?
解决方案 »
- rss 的制作
- 想做一个类似Visio 那样拖放图形,然后连线功能
- 团队开发如果把一个asp.net项目添加到vstf服务器上
- C#得到文件夹内文件数量
- c#图片处理,透明化,保存,急,各位帮忙!
- 想做一个 生成测试报告的程序
- C# ADO.NET 更新到数据库失败
- 运行时,如何使TextBox等控件像设计时那样可移动可改变大小呢?
- 急问???微软的所有控件如:vb,vc++的控件*.ocx,*.dll.现在在vc#,vb.net中还能调用并能使用吗???
- 使用Magiclibrary.dll第三方控件遇到的问题
- 请问FastSpring.Net这个 框架怎么使用,如果拿去开发一个项目,会很难开发吗?各位有没有开发的例子呢?
- .net 发传真求助
static DataSet ds = new DataSet();
OracleConnection conn; private void Form1_Load(object sender, EventArgs e)
{
//dataGridView1.AutoGenerateColumns = false;
conn = new OracleConnection(Source);
conn.Open();
oda.UpdateCommand = new OracleCommand("update table set serial_number = :sn ,next_station = :ns where rowid = :rid", conn);
oda.UpdateCommand.Parameters.Add("rid", OracleType.VarChar, 30).SourceColumn = "ROWID";
oda.UpdateCommand.Parameters.Add("sn", OracleType.VarChar, 30).SourceColumn = "SERIAL_NUMBER";
oda.UpdateCommand.Parameters.Add("ns", OracleType.VarChar, 40).SourceColumn = "NEXT_STATION"; oda.DeleteCommand = new OracleCommand("delete table where rowid = :rid", conn);
oda.DeleteCommand.Parameters.Add("rid", OracleType.VarChar).SourceColumn = "ROWID"; oda.InsertCommand = new OracleCommand("insert into table(serial_number,next_station) values(:sn , :ns )", conn);
oda.InsertCommand.Parameters.Add("sn", OracleType.VarChar).SourceColumn = "serial_number";
oda.InsertCommand.Parameters.Add("ns", OracleType.VarChar).SourceColumn = "next_station"; }
private void select_Click(object sender, EventArgs e)
{
try
{
ds.Clear();
string sql = "select rowid,serial_number,next_station from TABLE where serial_number like :sn";
oda.SelectCommand = new OracleCommand(sql, conn);
oda.SelectCommand.Parameters.Add("sn", OracleType.VarChar).Value = tb_SN.Text + "%";
oda.Fill(ds);
dataGridView1.DataSource = null;
dataGridView1.DataSource = ds.Tables[0];
} catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
} private void update_Click(object sender, EventArgs e)
{
this.Validate();
dataGridView1.EndEdit();
oda.Update(ds.Tables[0]);
}
private void insert_Click(object sender, EventArgs e)
{
this.Validate();
dataGridView1.EndEdit();
oda.Update(ds.Tables[0]);
}
private void btn_save_Click(object sender, EventArgs e) { }
////{
//// Class_book book = new Class_book();
//// try {
//// book.bookAmount =txt_amount.Text.ToString ();
//// book .bookID =txt_booknum .Text .Trim ();
//// book .bookName =txt_name .Text .Trim ();
//// book.bookPrice =txt_price .Text .Trim ();
//// book.bookPublish =txt_publish .Text .Trim ();
//// book.bookPublishDate =dtp_publishtime.Text .ToString ();
//// book.bookremain =txt_kcs .Text .Trim ();
//// book.bookWriter =txt_name .Text .Trim (); //// if(Femode =="0")
//// {
//// if (book.insert_book() != "0")
//// {
//// MessageBox.Show("图书增加失败");
//// return;
//// }
//// else
//// {
//// Frmbook.querybook();
//// this.Close();
//// }
//// }
//// } //// catch (Exception ex)
//// {}
//// finally {book =null ;}
////}
2.删除:
选择一行,
if (dgv_provider.SelectedRows.Count > 0 && dgv_provider.SelectedRows[0].Index != dgv_provider.Rows.Count)
{
DataGridViewRow myRow = new DataGridViewRow();
myRow = dgv_provider.SelectedRows[0];
string name = myRow.Cells["????"].Value.ToString();
if ((MessageBox.Show("确定要删除" + name + "???", "删除????", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) == DialogResult.Yes)
{
Class_provider provider = new Class_provider();
provider.Providerid = long.Parse(myRow.Cells["?????"].Value.ToString());
provider.Userid = PublicMember.pfsh;
provider.delete();
queryprovider();
}
if (dtb.Rows[DataGridView1.CurrentRow.Index].RowState==DataRowState.Added)
{
//添加记录
}
ElseIf (dtb.Rows[DataGridView1.CurrentRow.Index].RowState==DataRowState.Modified)
{
//修改记录
}
ElseIf (dtb.Rows[DataGridView1.CurrentRow.Index].RowState==DataRowState.Deleted)
{
//删除记录
}
删除的话就直接操作就好了。。