tblbooks.bookID,tblbooks.bookName,tblborrow.BorrowDate from tblborrow ,tblbooks "+ "where tblbooks.bookID in (select bookID from tblborrow where Number ='" + Session["id"] +"')";没有tblbooks.bookID=tblborrow.bookID 把这句加到where子句中。
TO: wangsaokui(无间道II(前传)) 哦,一言惊醒梦中人.真是多谢你. 还两个问题.那个好心人帮帮忙,很急的.如谦不够分可再加啊.
这样还不行,这样只能使得结果重复两次(不再是其中结果连续重复两次).
tblbooks表结构是这样的:
bookID(主键) |bookName |
-----
tblborrow表结构如下:
BorrowDate | bookID (是外键)
把这句加到where子句中。
哦,一言惊醒梦中人.真是多谢你.
还两个问题.那个好心人帮帮忙,很急的.如谦不够分可再加啊.
this.Controls.Add(dg);dg.AutoGenerateColumns = false;BoundColumn bc = new BoundColumn();
bc.DataField = "YourColumnName";
dg.Columns.Add(bc);
...dg.DataSource = ...;
dg.DataBind();public DataGrid MakeGrid()
{
mygrid.CellPadding=2;
mygrid.Attributes.Add("align","center");
mygrid.CellSpacing=0;
mygrid.Width=500;
mygrid.BorderWidth=1;
mygrid.BorderColor=ColorTranslator.FromHtml("Black");
mygrid.AutoGenerateColumns=false;
mygrid.ForeColor=ColorTranslator.FromHtml("Black");
mygrid.Font.Size=9;
mygrid.Font.Name="宋体";
mygrid.AllowSorting=true; ///sort命令的事件处理器 mygrid.SortCommand += new DataGridSortCommandEventHandler(Sort_Grid); ///设置headerstyle
mygrid.HeaderStyle.BackColor=ColorTranslator.FromHtml("Gold");
mygrid.HeaderStyle.ForeColor=ColorTranslator.FromHtml("Black");
mygrid.HeaderStyle.Font.Name="宋体";
mygrid.HeaderStyle.Font.Size=9;
mygrid.HeaderStyle.Font.Bold=true;
mygrid.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;