Question

C#.net代码解释~~~哪位高手帮个忙!!!!急急急

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

public SqlConnection GetConnection()
{
SqlConnection thisConncetion = new SqlConnection(ConfigurationSettings.AppSettings["conn"]);

return thisConncetion;
}

public DataTable dt(string query)
{
//返回一个DataTable类型
SqlConnection thisConncetion = GetConnection();
thisConncetion.Open();

SqlDataAdapter adapter = new SqlDataAdapter(query, thisConncetion);
DataTable dt = new DataTable();
adapter.Fill(dt);
thisConncetion.Close();
return dt;
}

public void InfoLists()
{
DataList1.DataSource = dt("select * from wb_info ");
DataList1.DataBind();
如果我想在和DataList1同个界面中加个DataList2. 再将DataList2与WB_INFOPATH数据绑定,接下来应该怎么写,请写出来,谢谢,写好立马采纳.在线等

Answer 1

不就是绑定数据啊

public SqlConnection GetConnection()
{
SqlConnection thisConncetion = new SqlConnection(ConfigurationSettings.AppSettings["conn"]); 获取连接字符串

return thisConncetion;
}

public DataTable dt(string query)
{
//返回一个DataTable类型
SqlConnection thisConncetion = GetConnection();
thisConncetion.Open(); 打开连接

SqlDataAdapter adapter = new SqlDataAdapter(query, thisConncetion);
DataTable dt = new DataTable();
adapter.Fill(dt); 用SqlDataAdapter(适配器)将数据填充到 datatable
thisConncetion.Close(); 关闭连接
return dt; 返回datatable
}

public void InfoLists()
{
DataList1.DataSource = dt("select * from wb_info ");
DataList1.DataBind();绑定数据,将数据绑定到datalist

Answer 2

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

public SqlConnection GetConnection()
{
SqlConnection thisConncetion = new SqlConnection(ConfigurationSettings.AppSettings["conn"]);

return thisConncetion;
}

public DataTable dt(string query)
{
//返回一个DataTable类型
SqlConnection thisConncetion = GetConnection(); //数据库连接对象
thisConncetion.Open(); //建立连接

SqlDataAdapter adapter = new SqlDataAdapter(query, thisConncetion); //数据库操纵对象
DataTable dt = new DataTable();
adapter.Fill(dt); //操作数据库
thisConncetion.Close(); //断开连接
return dt;
}

public void InfoLists()
{
DataList1.DataSource = dt("select * from wb_info ");
DataList1.DataBind();

Answer 3

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) //如果不是回发，则将查询的记录打印出来~~~
InfoLists();
}

public SqlConnection GetConnection()
{
SqlConnection thisConncetion = new SqlConnection(ConfigurationSettings.AppSettings["conn"]); //使用conn建立与数据库的连接

return thisConncetion;
}

public DataTable dt(string query)
{
//返回一个DataTable类型
SqlConnection thisConncetion = GetConnection();
thisConncetion.Open(); //得到一个数据表类型

SqlDataAdapter adapter = new SqlDataAdapter(query, thisConncetion);
DataTable dt = new DataTable();
adapter.Fill(dt); //将查询的记录绑定到表中
thisConncetion.Close(); //关闭连接
return dt;
}

public void InfoLists()
{
DataList1.DataSource = dt("select * from wb_info ");
DataList1.DataBind();//数据绑定到list中