asp.net C#中怎么实现获的数据库某个值 - 编程论坛

#2

willam2008-01-27 11:22

没人气

#3

catherienangel2008-01-28 08:49

回复 2# 的帖子

没太明你个意思：先写下我经常用的吧，希望对你有帮助：首先在web.config中configuration加入：<appSettings>
<add key="ConnectionString" value="provider=microsoft.jet.oledb.4.0;data source=|DataDirectory|\你数据库名字.mdb"/>
</appSettings>;然后在你的页面中：strconn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
OleDbConnection conn = new OleDbConnection(strconn);
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
string sql="....";

.....

#4

willam2008-01-28 13:59

就是rs("title")这个的值,
附给一个变量啊!

#5

jyoseyi2008-01-28 14:45

在c#中一样可以定义一个连接字符串
string sqlconn="server=172.0.0.1;database=……;username=……;password=……";

#6

willam2008-01-28 15:31

谢谢楼上的,,我问的不是这个问题...我问的是c#中,,怎么实现像asp中:

conn="driver={microsoft access driver (*.mdb)};dbq="&server.mappath("/data/data.mdb")
set rs=server.createobject("adodb.recordset")
sql="select top 1 title from new"
rs.open sql,conn,1,1

aa=rs("title") 获的这个字段的值
请问在 c#中怎么样实现
aa=rs("title")

#7

willam2008-01-28 16:40

谢谢大家..答案找到了
public partial class _Default : System.Web.UI.Page
{
    public string aa;
    protected void Page_Load(object sender, EventArgs e)
    {
        getcon str = new getcon();
        string constr = str.GetConnString();
        OleDbConnection con = new OleDbConnection(constr);
       OleDbDataAdapter gh = new OleDbDataAdapter("select S_title from title", con);
        DataSet g = new DataSet();
        gh.Fill(g, "title");
        Page.DataBind();
        Label1.DataBind();
        DataRow df = g.Tables[0].Rows[0];
        aa = (string)df["S_title"];

    }
}