这是一个GRIDVIEW读取ACCESS数据库的一个小程序
WINFORM代码如下: private void Form1_Load(object sender, EventArgs e)
{
string connStr, selectCmd; connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=POST.mdb";
selectCmd = "Select * From Customer Order By ID ASC";
OleDbConnection conn;
OleDbDataAdapter myAdapter;
DataSet myDataSet = new DataSet();
conn = new OleDbConnection(connStr);
myAdapter = new OleDbDataAdapter(selectCmd, conn);
myAdapter.Fill(myDataSet, "Customer"); dataGrid1.DataSource = myDataSet.Tables["Customer"];
}
因为我在一直做的是WINFORM 对WEB不了解 求高手说细点 越细越好
WINFORM代码如下: private void Form1_Load(object sender, EventArgs e)
{
string connStr, selectCmd; connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=POST.mdb";
selectCmd = "Select * From Customer Order By ID ASC";
OleDbConnection conn;
OleDbDataAdapter myAdapter;
DataSet myDataSet = new DataSet();
conn = new OleDbConnection(connStr);
myAdapter = new OleDbDataAdapter(selectCmd, conn);
myAdapter.Fill(myDataSet, "Customer"); dataGrid1.DataSource = myDataSet.Tables["Customer"];
}
因为我在一直做的是WINFORM 对WEB不了解 求高手说细点 越细越好
string connStr, selectCmd; connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=POST.mdb";
selectCmd = "Select * From Customer Order By ID ASC";
OleDbConnection conn;
OleDbDataAdapter myAdapter;
DataSet myDataSet = new DataSet();
conn = new OleDbConnection(connStr);
myAdapter = new OleDbDataAdapter(selectCmd, conn);
myAdapter.Fill(myDataSet, "Customer"); GridView.DataSource=myDataSet.Table["Customer"];
GridView.DataBind();代码需要放在 Page_Load里面
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataGridBind();
}
}
private void DataGridBind()
{
SqlDataAdapter sqlDa = new SqlDataAdapter("select * from tbItemSale",sqlCon);
DataSet ds = new DataSet();
sqlDa.Fill(ds, "tbItemSale");
DataGrid1.DataSource = ds.Tables[0].DefaultView;
DataGrid1.DataBind();
}
控件名不一样
换一个就可以了
dataGrid1.DataSource = myDataSet.Tables["Customer"]; 改成
dataGrid1.DataSource = myDataSet.Tables["Customer"];
dataGrid1.DataBind();注意要设置GridView的ID为dataGrid1,每列对应字段设置好
asp.net需要注意路径的问题,数据库链接字符串里Data Source=指向得加System.Web.HttpContext.Current.Server.MapPath(“..")获取其实际物理路径
比如
connStr =string.format( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}",System.Web.HttpContext.Current.Server.MapPath("/DB/POST.mdb"));
而且像那种DataGrid服务器控件要在数据源给定后,执行DataBind()方法。
三楼正解。
1个是代码要放的位置。
2个就是设定数据源后,还要执行绑定DataBind。补充一个,winform中显示的控件是datagridview, web中的控件是gridview