62,025
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Web.UI;
using System.Data.OleDb;
public partial class cqwz : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
int tt = 1;
if (Request.QueryString[0].Length == null)
{
Duqu(tt);
}
else
{
Duqu(Convert.ToInt32(Request.QueryString[0]));
}
}
protected void Duqu(int dutt)
{
string strConnection;
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConnection += "Data Source=";
strConnection += MapPath("../App_Data/game.mdb;");
strConnection += "Jet OLEDB:Database Password=zeng198822!@#";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
OleDbCommand cmd = new OleDbCommand("SELECT [newsname], [id] FROM [news] where([id='"+dutt+"'])", objConnection);
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Page.Title ="这里我想读取newsname中的数据!";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int tt = string.IsNullOrEmpty(Request.QueryString[0].ToString()) ? 1 : Convert.ToInt32(Request.QueryString[0]);
this.Page.Title = GetTitle(tt);
}
protected string GetTitle(int dutt)
{
object obj = null;
string strConnection;
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConnection += "Data Source=";
strConnection += MapPath("../App_Data/game.mdb;");
strConnection += "Jet OLEDB:Database Password=zeng198822!@#";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand cmd = new OleDbCommand("SELECT [newsname] FROM [news] WHERE [id] ='" + dutt + "'", objConnection);
objConnection.Open();
obj = cmd.ExecuteScalar();
objConnection.Close();
return Convert.ToString(obj);
}