Dim cnConn As New SqlConnection(ConfigurationSettings.AppSettings("ZS_Link")) Dim SQLselect As String
SQLselect = "SELECT ChargeName,Account,Note FROM Bill" Dim ds As DataSet
Dim cmdSelect As New SqlDataAdapter(SQLselect, cnConn) ds = New DataSet
cmdSelect.Fill(ds, "Bill") Datagrid2.DataSource = ds.Tables("Bill").DefaultView
If (ds.Tables(0).Rows.Count = 0) Then
Message2.InnerHtml = "还没有输入数据!"
Datagrid2.Visible = False
Else
Datagrid2.Visible = True
Datagrid2.DataBind()
End If
SQLselect = "SELECT ChargeName,Account,Note FROM Bill" Dim ds As DataSet
Dim cmdSelect As New SqlDataAdapter(SQLselect, cnConn) ds = New DataSet
cmdSelect.Fill(ds, "Bill") Datagrid2.DataSource = ds.Tables("Bill").DefaultView
If (ds.Tables(0).Rows.Count = 0) Then
Message2.InnerHtml = "还没有输入数据!"
Datagrid2.Visible = False
Else
Datagrid2.Visible = True
Datagrid2.DataBind()
End If
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("DateTimeValue", typeof(DateTime))); for (int i = 0; i < 9; i++) {
dr = dt.NewRow(); dr[0] = i;
dr[1] = "Ïî " + i.ToString();
dr[2] = DateTime.Now; dt.Rows.Add(dr);
} DataView dv = new DataView(dt);
return dv;
}
上面怎么换成数据库呢,对控件不是很熟,那位大哥帮帮我啊
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<Script Language="C#" Runat="Server">
public void Page_Load(Object src,EventArgs e)
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\db1.mdb;";
string strSel = "select * from Score";
DataSet ds = new DataSet(); OleDbConnection MyConn = new OleDbConnection(MyConnString);
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"Score"); score.DataSource = ds;
score.DataMember = "Score";
score.DataBind();
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<center>
<b>演示BoundColumn</b>
<asp:DataGrid id="score" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
AutoGenerateColumns="False"
>
<Columns>
<asp:BoundColumn HeaderText="姓名" DataField="Name" />
<asp:BoundColumn HeaderText="语文" DataField="Chinese" />
<asp:BoundColumn HeaderText="数学" DataField="Math" />
<asp:BoundColumn HeaderText="英语" DataField="English" />
</Columns>
</asp:DataGrid>
</center>
</form>
</body>
</html>
字段名 类型
IntegerValue Int32
StringValue varchar(长度自定吧)
DateTimeValue DateTime值共9条,n从0到8
IntegerValue StringValue DateTimeValue
n Ïî n 系统时间或者你输入就行
他们是一样的吗?
<%@import namespace="System.Data.OleDb"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
</head>
<script language="C#" runat="server">
void bingding(){
string connstr="Provider=MicroSoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("renshi.mdb");
OleDbDataAdapter ada=new OleDbDataAdapter("select * from zw",connstr);
DataSet ds=new DataSet();
ada.Fill(ds,"zw");
datalist1.DataSource=ds.Tables[0].DefaultView;
datalist1.DataBind();
}
void Page_Load(Object sender,EventArgs e){
if(!IsPostBack)
{
bingding();
}
}
void datalist_edit(Object sender,DataListCommandEventArgs e){
datalist1.EditItemIndex=e.Item.ItemIndex;
bingding();
}
void datalist_update(Object sender,DataListCommandEventArgs e){
string connstr="Provider=MicroSoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("renshi.mdb");
OleDbConnection conn=new OleDbConnection(connstr);
conn.Open();
string zwid=((Label)e.Item.FindControl("zwbm")).Text;
string zwmc=((TextBox)e.Item.FindControl("zwmc")).Text;
string sqlstr="update zw set zwmc='"+zwmc+"' where zwid='"+zwid+"'";
OleDbCommand cmd=new OleDbCommand(sqlstr,conn);
cmd.ExecuteNonQuery();
datalist1.EditItemIndex=-1;
bingding();
}
void datalist_cancel(Object sender,DataListCommandEventArgs e){
datalist1.EditItemIndex=-1;
bingding();
}</script>
<body>
<form runat="server">
<table width="100%" border="1">
<tr>
<td width="24%" bgcolor="#33FFFF"></td>
<td width="76%">
<asp:datalist ID="datalist1" runat="server" HeaderStyle-BackColor="#aaaadd"
ItemStyle-BackColor="#FFCCFF" AlternatingItemStyle-BackColor="#FFCCCC"
BorderWidth="1" BorderColor="red" EditItemStyle-BackColor="#66FFFF" Font-Size="11pt"
OnCancelCommand="datalist_cancel" OnEditCommand="datalist_edit" OnUpdateCommand="datalist_update"
Width="100%">
<headertemplate>人事管理--职务维护</headertemplate>
<itemtemplate>
<asp:linkbutton ID="button1" runat="server" Text="修改" CommandName="edit"/>
<%#DataBinder.Eval(Container.DataItem,"zwmc")%>
</itemtemplate>
<edititemtemplate>
职务编号:<asp:label ID="zwbm" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"zwid")%>'/><br>
职务名称:<asp:textbox ID="zwmc" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"zwmc")%>'/><br>
<asp:linkbutton ID="button2" runat="server" Text="更新" CommandName="update"/>
<asp:linkbutton ID="button3" runat="server" Text="取消" CommandName="cancel"/>
</edititemtemplate>
</asp:datalist><br></td>
</tr>
</table>
</form>
</body>
</html>