private void dgd_delete_DoubleClick(object sender, System.EventArgs e) { int x = this.dgd_modfiy.CurrentCell.RowNumber; int y = this.dgd_modfiy.CurrentCell.ColumnNumber; string strsel = "delete * from Info_Collect where Collect_ID = '"+dgd_modfiy[x,y].ToString()+"'"; DialogResult MsgBoxResult;//设置对话框的返回值 MsgBoxResult = MessageBox.Show("确认要删除吗?",//对话框的显示内容 "提示",//对话框的标题 MessageBoxButtons.YesNo,//定义对话框的按钮,这里定义了YSE和NO两个按钮 MessageBoxIcon.Exclamation,//定义对话框内的图表式样,这里是一个黄色三角型内加一个感叹号 MessageBoxDefaultButton.Button2);//定义对话框的按钮式样 if (MsgBoxResult == DialogResult.Yes)//如果对话框的返回值是YES(按"Y"按钮) { DbManagerSQL.ExecuteSql(strsel); } }
private void dgd_modfiy_DoubleClick(object sender, System.EventArgs e) { int x = this.dgd_modfiy.CurrentCell.RowNumber; int y = this.dgd_modfiy.CurrentCell.ColumnNumber; string strsel = "select Collect_PName,Collect_URL,Collect_Type,Collect_Address,Collect_Regex from Info_Collect where Collect_ID = '"+dgd_modfiy[x,y].ToString()+"'";
{
int x = this.dgd_modfiy.CurrentCell.RowNumber;
int y = this.dgd_modfiy.CurrentCell.ColumnNumber;
string strsel = "delete * from Info_Collect where Collect_ID = '"+dgd_modfiy[x,y].ToString()+"'";
DialogResult MsgBoxResult;//设置对话框的返回值 MsgBoxResult = MessageBox.Show("确认要删除吗?",//对话框的显示内容 "提示",//对话框的标题 MessageBoxButtons.YesNo,//定义对话框的按钮,这里定义了YSE和NO两个按钮 MessageBoxIcon.Exclamation,//定义对话框内的图表式样,这里是一个黄色三角型内加一个感叹号 MessageBoxDefaultButton.Button2);//定义对话框的按钮式样 if (MsgBoxResult == DialogResult.Yes)//如果对话框的返回值是YES(按"Y"按钮) {
DbManagerSQL.ExecuteSql(strsel); }
}
{
int x = this.dgd_modfiy.CurrentCell.RowNumber;
int y = this.dgd_modfiy.CurrentCell.ColumnNumber;
string strsel = "select Collect_PName,Collect_URL,Collect_Type,Collect_Address,Collect_Regex from Info_Collect where Collect_ID = '"+dgd_modfiy[x,y].ToString()+"'";
string connectionString = "server=127.0.0.1;database=Info;uid=sa;pwd=sa;";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(strsel,conn);
conn.Open();
SqlDataReader reader; reader = cmd.ExecuteReader();
while(reader.Read())
{
this.txt_name.Text = reader.GetString(0);
this.txt_url.Text = reader.GetString(1);
this.cmb_server.Text = reader.GetString(2);
this.txt_collect.Text = reader.GetString(3);
this.txt_reg.Text = reader.GetString(4);
}
reader.Close();
cmd.Dispose();
conn.Close(); } private void btn_modify_Click(object sender, System.EventArgs e)
{
string name = this.txt_name.Text.Trim();
string url = this.txt_url.Text.Trim();
string server = this.cmb_server.Text;
string collect = this.txt_collect.Text.Trim();
string reg = this.txt_reg.Text.Trim();
string strupdate = "update Info_Collect set Collect_PName = '"+name+"',Collect_URL = '"+url+"',Collect_Type ='"+server+"',Collect_Address = '"+collect+"',Collect_Regex = '"+reg+"' where Collect_PName = '"+name+"' and Collect_Type = '"+server+"'";
DbManagerSQL.ExecuteSql(strupdate);
MessageBox.Show("修改成功!");
}
==>>管理
==>