public void DataGrid1_ItemCommand(object sender, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName=="Select")
{
i=e.Item.Cells[0].Text;
DataGrid1.SelectedIndex=e.Item.ItemIndex;
this.RRR(i);}
}
public void RRR(string j)
{
if(!db1.IsOpen())
{
db1.DBOpen(); }
else
{
SqlCommand cmdSelect=new SqlCommand("Select * From MeetingRoomBasic Where RoomNO=@ID",db1.ReturnDBCon());
cmdSelect.Parameters.Add("@ID",j);
SqlDataReader SelectReader=cmdSelect.ExecuteReader();
SelectReader.Read();
TextBox1.Text=(string)SelectReader.GetSqlString(0);
TextBox2.Text=(string)SelectReader.GetSqlString(1);
TextBox3.Text=(string) SelectReader.GetSqlString(2);
TextBox4.Text=(string)SelectReader.GetSqlString(4);
TextBox5.Text=(string)SelectReader.GetSqlString(3);
TextBox6.Text=(string)SelectReader.GetSqlString(5);
SelectReader.Close();
db1.DBClose();
}
}
{
if(e.CommandName=="Select")
{
i=e.Item.Cells[0].Text;
DataGrid1.SelectedIndex=e.Item.ItemIndex;
this.RRR(i);}
}
public void RRR(string j)
{
if(!db1.IsOpen())
{
db1.DBOpen(); }
else
{
SqlCommand cmdSelect=new SqlCommand("Select * From MeetingRoomBasic Where RoomNO=@ID",db1.ReturnDBCon());
cmdSelect.Parameters.Add("@ID",j);
SqlDataReader SelectReader=cmdSelect.ExecuteReader();
SelectReader.Read();
TextBox1.Text=(string)SelectReader.GetSqlString(0);
TextBox2.Text=(string)SelectReader.GetSqlString(1);
TextBox3.Text=(string) SelectReader.GetSqlString(2);
TextBox4.Text=(string)SelectReader.GetSqlString(4);
TextBox5.Text=(string)SelectReader.GetSqlString(3);
TextBox6.Text=(string)SelectReader.GetSqlString(5);
SelectReader.Close();
db1.DBClose();
}
}
解决方案 »
- C# WinForm中使用DevExpress DockManager控件问题 ?急急急
- C# 实现窗体抖动
- 无法在安装vs2010时同时安装msdn
- 把datagridview 数据tostring 时怎么固定每一列的宽度????
- 急!!!用C#在PDA上实现数据保存问题???
- 高人看一下c#的动态linkbutton分组循环这怎么做
- 请问visual studio 2005速成版本企业版本有什么不同
- 类的属性与DATAROW 的列关联
- 类型转换内存溢出问题
- 高手帮我分析一下-浏览器
- 怎么除去CrystalReport的自带的工具栏
- 怎样把文本文件中的数据倒入 winform的datagrid中
在DataGrid的ItemDataBound事件中处理private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
e.Item.Attributes["ondblclick"] = "alert('write at here');";
}
}