110,586
社区成员
发帖
与我相关
我的任务
分享
namespace cj_sys
{
public partial class Form7 : Form
{
public Form7()
{
InitializeComponent();
}
conns conn_conn = new conns();
string sql_str = "select sd_id as 序列号,sd_names as 抽奖人姓名,
sd_nums as 水单号,sd_tel as 联系方式,sd_flag as 是否参加抽奖 from cj_main_sd order by sd_date desc";
string del_str = "delete from cj_main_sd";
private SqlDataAdapter find_do;
private DataSet ds;
private void Form7_Load(object sender, EventArgs e)
{
formload();
//将所有记录读入DataGridView
}
private void formload()
{
SqlConnection conn = new SqlConnection(conn_conn.conn_str);
SqlCommand cmd = new SqlCommand(sql_str, conn);
find_do = new SqlDataAdapter();
find_do.SelectCommand = cmd;
ds = new DataSet();
try
{
find_do.Fill(ds, "rs");
}
catch (System.Exception sqler)
{
MessageBox.Show("数据库不存在或用户名密码错误!", sqler.Message,MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
dataGridView1.DataSource = ds.Tables["rs"];
dataGridView1.Columns[0].FillWeight = 40;
dataGridView1.Columns[1].FillWeight = 60;
dataGridView1.Columns[2].FillWeight = 80;
dataGridView1.Columns[3].FillWeight = 70;
dataGridView1.Columns[4].FillWeight = 40;
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].ReadOnly = true;
dataGridView1.Columns[2].ReadOnly = true;
dataGridView1.Columns[3].ReadOnly = true;
dataGridView1.Columns[4].ReadOnly = true;
}
private void button1_Click(object sender, EventArgs e)
{
//需要取得datagrid选中的值,并弹出form7_edit
}
try
{
seled = dataGridView1.CurrentRow.Cells[0].Value.ToString();
}
catch (System.Exception)
{
MessageBox.Show("值为空不能修改!", "修改操作错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}