在gridcontrol中,我用的绑定数据的方法如下:
string connectionString = "Integrated Security=False;User ID=sa;Password=123456;Initial Catalog=RDSS3;Server=.";
SqlConnection con = new SqlConnection(connectionString);
string queryString = "select TaskNum as '任务编号',TaskDesc as '任务描述' ,Creator as '创建人',CreatDate as '创建时间',ProjectNum as '项目编号',ExpAim as '试验目的',Re as '备注'from dbo.ExpTask";
SqlDataAdapter sda = new SqlDataAdapter(queryString,con);
DataSet ds = new DataSet();
sda.Fill(ds);
gcTask.DataSource = ds.Tables[0]; 如何在gridcontrol中删除焦点所在的行
string connectionString = "Integrated Security=False;User ID=sa;Password=123456;Initial Catalog=RDSS3;Server=.";
SqlConnection con = new SqlConnection(connectionString);
string queryString = "select TaskNum as '任务编号',TaskDesc as '任务描述' ,Creator as '创建人',CreatDate as '创建时间',ProjectNum as '项目编号',ExpAim as '试验目的',Re as '备注'from dbo.ExpTask";
SqlDataAdapter sda = new SqlDataAdapter(queryString,con);
DataSet ds = new DataSet();
sda.Fill(ds);
gcTask.DataSource = ds.Tables[0]; 如何在gridcontrol中删除焦点所在的行
//删除单条记录
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DialogResult dialogResult = MessageBox.Show("是否删除该记录?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (dialogResult==DialogResult.OK)
{
string taskNum = gvTask.GetFocusedRowCellValue("任务编号").ToString();
string connectionString = "Integrated Security=False;User ID=sa;Password=2630989;Initial Catalog=RDSS3;Server=.";
SqlConnection con = new SqlConnection(connectionString);
string deleteString = "delete from dbo.ExpTask where TaskNum='" + taskNum + "'";
SqlCommand cmd = new SqlCommand(deleteString, con);
con.Open();
cmd.ExecuteNonQuery();
gvTask.DeleteRow(gvTask.FocusedRowHandle);
}
else
{
return;
}
}
自己写的,运行没出问题,呵呵
string s1= gridView1.GetFocusedRowCellValue("照片名称").ToString()
它总是得到焦点行的下一行,不知道为什么