OleDbConnection connLogin = new OleDbConnection();
connLogin.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath + @"\\cms.mdb" ;
connLogin.Open(); string strSQL = "select * from login"; DataSet Myds = new DataSet();
OleDbDataAdapter dbCommand = new OleDbDataAdapter(strSQL,connLogin );
dbCommand.Fill(Myds, "login");
DataTable dtTable = Myds.Tables["login"];
后面不会写了,我想显示出login表中某一字段的内容,谁能教我一下.
connLogin.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath + @"\\cms.mdb" ;
connLogin.Open(); string strSQL = "select * from login"; DataSet Myds = new DataSet();
OleDbDataAdapter dbCommand = new OleDbDataAdapter(strSQL,connLogin );
dbCommand.Fill(Myds, "login");
DataTable dtTable = Myds.Tables["login"];
后面不会写了,我想显示出login表中某一字段的内容,谁能教我一下.
DataKeyField = "id";
DataBind();得先创建一个显示纪录的空间 DataGrid
i是行号
this.datagridview1.datasource=myds.tables["login"];
就可以了,很简单的
MessageBox.Show(Myds.Tables["login"].Rows[1]["UserName"].ToString );
我这样写的,可是报错,说无法从object转换成string
MessageBox.Show(Myds.Tables[ "login "].Rows[1][ "UserName "].ToString );
我这样写的,可是报错,说无法从object转换成string
+括号
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class Default3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = getDate().Tables[0];
GridView1.DataSource =dt;
GridView1.DataBind();
for (int i = 0; i < dt.Rows.Count; i++)
{
Response.Write(dt.Rows[i]["你要显示的字段"].ToString());
}
}
public DataSet getDate()
{
string sql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\test.xls;Extended Properties=\"Excel 8.0\"";
OleDbConnection conn = new OleDbConnection(sql);
OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$]", conn);//工作表名就是Excel显示区下面的工作区名
OleDbDataAdapter da = new OleDbDataAdapter(cmd); //读取Excel表格
DataSet ds = new DataSet();
da.Fill(ds);
return ds; }
}
{
OleDbConnection connLogin = new OleDbConnection();
connLogin.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= "+Application.StartupPath + @ "\\cms.mdb " ;
connLogin.Open();
string strSQL = "select * from login ";
DataSet Myds = new DataSet();
OleDbDataAdapter dbCommand = new OleDbDataAdapter(strSQL,connLogin );
dbCommand.Fill(Myds, "login ");
DataTable dtTable = Myds.Tables[ "login"];
return ds.Tables["login"];
}
----------
MessageBox.Show(Myds.Tables[ "login "].Rows[1][ "UserName "].ToString );
我这样写的,可是报错,说无法从object转换成string
----------
.ToString()要加括号,这是方法,不是属性,还有,Rows[i],这里是i,不是123的1有了数据源,让后就按楼上的兄弟说得绑定就ok了,还记得要Initial