查人人中国名人网厨房吊顶硅钙板好吗?:关于ASP.NET的数据库查询问题
来源：百度文库 编辑：查人人中国名人网 时间：2024/05/06 02:12:58
想在<% %> 的代码段里加MS SQL的查询结果，但是用BIND绑不了。不知道为啥。。
用ASP的话，直接用rs("counter")就可以获得查询项的结果。 。NET怎么获得呢？
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<Script Languate="VB" Runat="Server">
Sub Page_Load(sender As Object, e As Eventargs)
'创建数据连接
Dim objConn As New OleDbConnection()
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("数据库名")
objConn.Open()
'创建 DataReader 对象实例
Dim objCmd As New OleDbCommand()
objCmd.Connection = objConn
objCmd.CommandText = "select * From chwu where 条件"
Dim objReader As OleDbDataReader = objCmd.ExecuteReader()
if objReader.read() = true then
response.write (objReader.item("字段名"))
end if
end sub
</script>
又改一下.如果你的.net环境没问题.一定行.我试过.保存为.net
objReader.item("字段名")它就可以获得查询项的结果
System.Data.OleDb.OleDbConnection Conn=new System.Data.OleDb.OleDbConnection();
Conn.ConnectionString="Provider=SQLOLEDB.1;Password=88888888;Persist Security Info=True;User ID=sa;Initial Catalog=ProjectManager;Data Source=ZHAOBO";
Conn.Open();
System.Data.OleDb.OleDbCommand Cmd=Conn.CreateCommand();
System.Data.OleDb.OleDbDataReader Reader;
Cmd.CommandText="select FromUserID,ToUserID,message,SendTime,isRead,ReadTime,FromUser,ToUser from vMessage where id="+ID.ToString();
Reader=Cmd.ExecuteReader();
if(Reader.HasRows)
{
if(Reader.Read())
{
m_FromUserID=Reader.GetInt32(0);
m_ToUserID=Reader.GetInt32(1);
this.m_msg=Reader.GetString(2);
this.m_SendTime=Reader.GetDateTime(3).ToString();
this.m_IsRead=Reader.GetInt32(4);
this.m_ReadTime=Reader.GetDateTime(5).ToString();
this.m_FromUserLogName=Reader.GetString(6);
this.m_ToUserLogName=Reader.GetString(7);
}
}