急！！回答立结！！

rqxiang 2003-04-09 03:50:56

在ASP.net的DataGrid控件中，点击选择按钮如何连接到数据库中，显示详细信息？
最好附源码！谢谢！！！！

...全文

43 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

rqxiang 2003-04-09

打赏
举报

zlcoolzl 2003-04-09

打赏
举报

OleDbConnection DBCon;
......
DBCon.Open();

System.Data.OleDb.OleDbDataAdapter dbda=new OleDbDataAdapter("SELECT varRoleID AS 角色编号, varRoleName AS 角色名称," +
"varRoleIntro AS 角色说明, VarRoleConvene AS 角色权限 "+
"FROM bRole",Connection.DBCon);

DataSet ds=new DataSet();
dbda.Fill(ds,"test");

DataGrid1.DataSource =ds;
DataGrid1.DataBind();

Knight94 2003-04-09

打赏
举报

？用DataGrid连接数据库好像不行吧？

yarshray 2003-04-09

打赏
举报

http://chs.gotdotnet.com/quickstart/aspplus/

Knight94 2003-04-09

打赏
举报

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>

<html>
<script runat="server">

ICollection CreateDataSource()
{
DataTable dt = new DataTable();
DataRow dr;

dt.Columns.Add(new DataColumn("IntegerValue", typeof(Int32)));
dt.Columns.Add(new DataColumn("StringValue", typeof(string)));
dt.Columns.Add(new DataColumn("CurrencyValue", typeof(double)));

for (int i = 0; i < 5; i++)
{
dr = dt.NewRow();

dr[0] = i;
dr[1] = "Item " + i.ToString();
dr[2] = 1.23 * (i+1);

dt.Rows.Add(dr);
}

DataView dv = new DataView(dt);
return dv;
}

void Page_Load(Object sender, EventArgs e)
{

if (!IsPostBack)
{
// Load this data only once.
ItemsGrid.DataSource = CreateDataSource();
ItemsGrid.DataBind();
}

}

void Item_Bound(Object sender, DataGridItemEventArgs e)
{

ListItemType itemType = (ListItemType)e.Item.ItemType;

if ((itemType != ListItemType.Header) &&
(itemType != ListItemType.Footer) &&
(itemType != ListItemType.Separator))
{

// Get the IntegerValue cell from the grid's column collection.
TableCell intCell = (TableCell)e.Item.Controls[0];

// Add attributes to the cell.
intCell.Attributes.Add("id", "intCell" + e.Item.ItemIndex.ToString());
intCell.Attributes.Add("OnClick",
"Update_intCell" +
e.Item.ItemIndex.ToString() +
"()");

// Add attributes to the row.
e.Item.Attributes.Add("id", "row" + e.Item.ItemIndex.ToString());
e.Item.Attributes.Add("OnDblClick",
"Update_row" +
e.Item.ItemIndex.ToString() +
"()");

}

}

</script>