我现在有一个aspx页,下面是其中的代码:
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data.OleDb" %>……
……<script language="c#" runat="server" >String mid;Database allcity = new Database(ConfigurationSettings.AppSettings["数据库路径"]);
void Page_Load(Object scr, EventArgs e)
{
if(!IsPostBack)
{ Database alltrip = new Database(ConfigurationSettings.AppSettings["数据库路径"]);
DataList_tuijian.DataSource=(alltrip.SQL_SelectSQL_DataSet("select top 6 * from tripproduct where trip_flag=1 order by id desc","tripproduct")).Tables["tripproduct"];
DataList_tuijian.DataBind();
DataList_new_product.DataSource=(alltrip.SQL_SelectSQL_DataSet("select top 6 * from tripproduct order by id desc","tripproduct")).Tables["tripproduct"];
DataList_new_product.DataBind(); }
}可以看到,上面红色字体的Database和SQL_SelectSQL_DataSet类都是自己编写的。但是这两个类的代码都找不到了,谁能根据一下我现在给出的代码帮我写一下这两个的代码,应该不难吧,拜托啦!Database应该就是连接一下数据库,SQL_SelectSQL_DataSet应该是绑定个DataList吧?
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data.OleDb" %>……
……<script language="c#" runat="server" >String mid;Database allcity = new Database(ConfigurationSettings.AppSettings["数据库路径"]);
void Page_Load(Object scr, EventArgs e)
{
if(!IsPostBack)
{ Database alltrip = new Database(ConfigurationSettings.AppSettings["数据库路径"]);
DataList_tuijian.DataSource=(alltrip.SQL_SelectSQL_DataSet("select top 6 * from tripproduct where trip_flag=1 order by id desc","tripproduct")).Tables["tripproduct"];
DataList_tuijian.DataBind();
DataList_new_product.DataSource=(alltrip.SQL_SelectSQL_DataSet("select top 6 * from tripproduct order by id desc","tripproduct")).Tables["tripproduct"];
DataList_new_product.DataBind(); }
}可以看到,上面红色字体的Database和SQL_SelectSQL_DataSet类都是自己编写的。但是这两个类的代码都找不到了,谁能根据一下我现在给出的代码帮我写一下这两个的代码,应该不难吧,拜托啦!Database应该就是连接一下数据库,SQL_SelectSQL_DataSet应该是绑定个DataList吧?
{
try
{
SqlConnection con = new SqlConnection(sConnection);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sSql, con);
DataSet ds = new DataSet();
adapter.Fill(ds);
con.Close();
return ds;
}
catch
{
return null;
}
/*
string sSql="select top 6 * from tripproduct where trip_flag=1 order by id desc";
DataList_tuijian.DataSource=GetTable(ConfigurationSettings.AppSettings["数据库路径"],sSql);
DataList_tuijian.DataBind();
sSql="select top 6 * from tripproduct order by id desc";
DataList_new_product.DataSource=GetTable(ConfigurationSettings.AppSettings["数据库路径"],sSql);
DataList_new_product.DataBind();
*/
}
你既然知道很简单而且本来都是你自己编的,那你还为什么要别人来帮你编呢?
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;namespace WindowsApplication1
{
public class Database
{
private string m_SqlConn;
public Database(string p_SqlConn)
{
m_SqlConn = p_SqlConn;
} public DataSet SQL_SelectSQL_DataSet(string p_SqlSelectComm,string p_ScrTable)
{
DataSet _ReturnDataSet =new DataSet();
try
{
SqlDataAdapter _SqlDataAdapert = new SqlDataAdapter(p_SqlSelectComm, m_SqlConn);
_SqlDataAdapert.Fill(_ReturnDataSet, p_ScrTable);
}
catch
{
}
return _ReturnDataSet;
}
}
}命名空间自己改下
好像有点接近了,麻烦能不能按照Datebase类和SQL_SelectSQL_DataSet方法来写代码,就是那种我直接复制进页面就可以用的方式,可以吗?麻烦你了!