asp代码转换成.net

来源：百度知道 编辑：UC知道 时间：2024/06/02 06:30:34
set rs3=conn.execute("select * from info where 1=1")
for i=1 to 300
if not rs3.eof then %>
<%if mid(rs3("shengtime"),6,3)=month(now())&day(now()) or mid(rs3("shengtime"),5,4)=month(now())&day(now()) then %>,
<%=rs3("username")%>
<%end if%>
<%
rs3.movenext()
end if
next
rs3.close()
set rs3=nothing

数据库名为minjing.mdb.
数据库连接是这样写的:
dim connstr
connstr="provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("db/minjing.mdb")
set conn=server.CreateObject("adodb.connection")
conn.open connstr
sub CloseConn()
conn.close
set conn=nothing
end sub

请高手指点啊..在线等
其它在这个表里面有一个出生日期这个字段.要叛断今天是他的生日的话,就把他的名字显示出来...很简单.望高手指点啊

在ASP.NET页面里添加一个GridView
然后把下面代码复制到页面代码文件中。就是.cs的那个

using System;
using System.Data;
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;
using System.Data;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindBirthday();
}

/// <summary>
/// 显示所有近日生日的人
/// </summary>
private void BindBirthday()
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=" + Server.MapPath(".") + "\\minjing.mdb";//将数据库存放在根目录
using (OleDbConne