using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// SqlConnection con = new SqlConnection("server=dbtalbe;uid=sa;pwd=sa;database=addb;");
//con.Open();
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["strconn"]);
con.Open();
/*写入数据库
SqlCommand cmd = new SqlCommand("INSERT INTO [Ad_Sort] ([sortname]) VALUES ('首页广告')",con);
cmd.ExecuteNonQuery();
Response.Write("写入成功!");
con.Close();
*/
string strsql = "select * from ad_sort order by id desc";
//读取数据
SqlDataAdapter sda = new SqlDataAdapter(strsql, con);
DataSet ds = new DataSet();
sda.Fill(ds, "ad_sort");
this.hotcommentlist.DataSource = ds;
this.hotcommentlist.DataBind();
//读取单个数据
SqlDataAdapter Set = new SqlDataAdapter(strsql, con);
DataSet Rs = new DataSet();
Set.Fill(Rs,"ad_sort");
//DataRowView mydrview = Rs.Tables["ad_sort"].DefaultView[0];
this.sortname.InnerHtml = Convert.ToString(Rs.Tables["ad_sort"].DefaultView[0].Row[1]);
/*
SqlDataAdapter Set = new SqlDataAdapter(strsql,con);
DataSet Rs = new DataSet();
Set.Fill(Rs,"ad_sort");
this.sortname.InnerHtml = Convert.ToString(Rs.Tables["ad_sort"].DefaultView[0].Row[1]);
this.sortname.InnerHtml = Convert.ToString(Rs.Tables["ad_sort"].DefaultView[0].Row[1]);
*/
Swww.169mnk.comqlCommand cmd = new SqlCommand(strsql, con);
SqlDataReader Res1 = cmd.ExecuteReader();
string listbody="";
listbody += ("<table border=0 ");
listbody+=("<tr><td>ExecuteReader读取数据</td></tr>");
listbody += ("<tr><th>编号</th><th>名称</th></tr>");
while (Res1.Read())
{
listbody += ("<tr>");
listbody += ("<td align='center'>" + Res1["id"].ToString() + "</td>");
listbody += ("<td align='left'>" + Res1["sortname"].ToString() + "</td>");
listbody += ("</tr>");
}
listbody += ("</table>");
list2.InnerHtml = listbody;
Res1.Close();
con.Close();
}
}
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// SqlConnection con = new SqlConnection("server=dbtalbe;uid=sa;pwd=sa;database=addb;");
//con.Open();
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["strconn"]);
con.Open();
/*写入数据库
SqlCommand cmd = new SqlCommand("INSERT INTO [Ad_Sort] ([sortname]) VALUES ('首页广告')",con);
cmd.ExecuteNonQuery();
Response.Write("写入成功!");
con.Close();
*/
string strsql = "select * from ad_sort order by id desc";
//读取数据
SqlDataAdapter sda = new SqlDataAdapter(strsql, con);
DataSet ds = new DataSet();
sda.Fill(ds, "ad_sort");
this.hotcommentlist.DataSource = ds;
this.hotcommentlist.DataBind();
//读取单个数据
SqlDataAdapter Set = new SqlDataAdapter(strsql, con);
DataSet Rs = new DataSet();
Set.Fill(Rs,"ad_sort");
//DataRowView mydrview = Rs.Tables["ad_sort"].DefaultView[0];
this.sortname.InnerHtml = Convert.ToString(Rs.Tables["ad_sort"].DefaultView[0].Row[1]);
/*
SqlDataAdapter Set = new SqlDataAdapter(strsql,con);
DataSet Rs = new DataSet();
Set.Fill(Rs,"ad_sort");
this.sortname.InnerHtml = Convert.ToString(Rs.Tables["ad_sort"].DefaultView[0].Row[1]);
this.sortname.InnerHtml = Convert.ToString(Rs.Tables["ad_sort"].DefaultView[0].Row[1]);
*/
Swww.169mnk.comqlCommand cmd = new SqlCommand(strsql, con);
SqlDataReader Res1 = cmd.ExecuteReader();
string listbody="";
listbody += ("<table border=0 ");
listbody+=("<tr><td>ExecuteReader读取数据</td></tr>");
listbody += ("<tr><th>编号</th><th>名称</th></tr>");
while (Res1.Read())
{
listbody += ("<tr>");
listbody += ("<td align='center'>" + Res1["id"].ToString() + "</td>");
listbody += ("<td align='left'>" + Res1["sortname"].ToString() + "</td>");
listbody += ("</tr>");
}
listbody += ("</table>");
list2.InnerHtml = listbody;
Res1.Close();
con.Close();
}
}