大家好,有个问题想请教,下面是我写的一段代码:
public partial class BBS_TitlesList : System.Web.UI.Page
{
string curPage;
String sqlconn = "Server=.\\SQLEXPRESS;DataBase=Test;Integrated Security=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.lblPageCur.Text = "1";
dataGridBind();
}
}
public void dataGridBind()
{
SqlConnection mysqlConn = new SqlConnection(sqlconn);
mysqlConn.Open();
SqlCommand myCommand = new SqlCommand("SELECT Areas.area_ID, Areas.area_Name AS 帖子区, Titles.title_ID, Titles.title AS 帖子主题, Titles.body, Titles.updateDate AS 创建时间, Titles.lookNum AS 访问次数, Titles.answerNum AS 回复次数, Titles.User_Name AS 发表人 FROM Areas INNER JOIN Titles ON Areas.area_ID = Titles.area_ID WHERE (Areas.area_ID = @area_ID)", mysqlConn);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = myCommand;
DataSet ds = new DataSet();
da.Fill(ds, "SqlDataSource1");
curPage = this.lblPageCur.Text;
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = 5;
pds.DataSource = ds.Tables["SqlDataSource1"].DefaultView;
pds.CurrentPageIndex = Convert.ToInt32(curPage) - 1;
this.lblPageTotal.Text = pds.PageCount.ToString();
this.btnshangyiye.Enabled = true;
this.btnxiayiye.Enabled = true;
if (curPage == "1")
{
this.btnshangyiye.Enabled = false;
}
if (curPage == pds.PageCount.ToString())
{
this.btnxiayiye.Enabled = false;
}
this.DataList1.DataSource = pds;
this.DataList1.DataBind();
mysqlConn.Close(); }
protected void btnshouye_Click(object sender, EventArgs e)
{
this.lblPageCur.Text = "1";
dataGridBind();
}
protected void btnshangyiye_Click(object sender, EventArgs e)
{
this.lblPageCur.Text = Convert.ToString(Convert.ToInt32(this.lblPageCur.Text) - 1);
dataGridBind();
}
protected void btnxiayiye_Click(object sender, EventArgs e)
{
this.lblPageCur.Text = Convert.ToString(Convert.ToInt32(this.lblPageCur.Text) + 1);
dataGridBind();
}
protected void btnweiye_Click(object sender, EventArgs e)
{
this.lblPageCur.Text = this.lblPageTotal.Text;
dataGridBind();
}
}
加颜色的那些出错了,我想问一下,如何将SELECT语句中的几个表合并成一个表呢?才能正确使用da.Fill(ds, "表");和pds.DataSource = ds.Tables["表"].DefaultView;呢?
public partial class BBS_TitlesList : System.Web.UI.Page
{
string curPage;
String sqlconn = "Server=.\\SQLEXPRESS;DataBase=Test;Integrated Security=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.lblPageCur.Text = "1";
dataGridBind();
}
}
public void dataGridBind()
{
SqlConnection mysqlConn = new SqlConnection(sqlconn);
mysqlConn.Open();
SqlCommand myCommand = new SqlCommand("SELECT Areas.area_ID, Areas.area_Name AS 帖子区, Titles.title_ID, Titles.title AS 帖子主题, Titles.body, Titles.updateDate AS 创建时间, Titles.lookNum AS 访问次数, Titles.answerNum AS 回复次数, Titles.User_Name AS 发表人 FROM Areas INNER JOIN Titles ON Areas.area_ID = Titles.area_ID WHERE (Areas.area_ID = @area_ID)", mysqlConn);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = myCommand;
DataSet ds = new DataSet();
da.Fill(ds, "SqlDataSource1");
curPage = this.lblPageCur.Text;
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = 5;
pds.DataSource = ds.Tables["SqlDataSource1"].DefaultView;
pds.CurrentPageIndex = Convert.ToInt32(curPage) - 1;
this.lblPageTotal.Text = pds.PageCount.ToString();
this.btnshangyiye.Enabled = true;
this.btnxiayiye.Enabled = true;
if (curPage == "1")
{
this.btnshangyiye.Enabled = false;
}
if (curPage == pds.PageCount.ToString())
{
this.btnxiayiye.Enabled = false;
}
this.DataList1.DataSource = pds;
this.DataList1.DataBind();
mysqlConn.Close(); }
protected void btnshouye_Click(object sender, EventArgs e)
{
this.lblPageCur.Text = "1";
dataGridBind();
}
protected void btnshangyiye_Click(object sender, EventArgs e)
{
this.lblPageCur.Text = Convert.ToString(Convert.ToInt32(this.lblPageCur.Text) - 1);
dataGridBind();
}
protected void btnxiayiye_Click(object sender, EventArgs e)
{
this.lblPageCur.Text = Convert.ToString(Convert.ToInt32(this.lblPageCur.Text) + 1);
dataGridBind();
}
protected void btnweiye_Click(object sender, EventArgs e)
{
this.lblPageCur.Text = this.lblPageTotal.Text;
dataGridBind();
}
}
加颜色的那些出错了,我想问一下,如何将SELECT语句中的几个表合并成一个表呢?才能正确使用da.Fill(ds, "表");和pds.DataSource = ds.Tables["表"].DefaultView;呢?
你不是用的inner join on连的了吗,还有那个转换成中文不是那样写的吧。
myCommand .Parameters.AddWithValue("@area_ID",1);