sqldatasource

Question

string pjName = Master.GetDataRow(rowIndex)["PJName"].ToString();
       string detailStr = "select docno,(substring(WPDate,7,5)+'/'+substring(WPDate,4,2)+'/'+" +
           "substring(WPDate,0,3)) as WPDate,ExecuteBy,subject,status,(substring(startDate,7,5)+'/'+" +
           "substring(startDate,4,2)+'/'+substring(startDate,0,3)+' '+startTime) as Start," +
           "(substring(compDate,7,5)+'/'+substring(compDate,4,2)+'/'+substring(compDate,0,3)+' '+" +
           "compTime) as Finish,(substring(WillCompDate,7,5)+'/'+substring(WillCompDate,4,2)+'/'+" +
           "substring(WillCompDate,0,3)) as WillCompDate,space(3) as Seq from wplan where docType='PJ' " +
           "and PJName='" + pjName + "'";
SqlDataSource1.SelectCommand = detailStr;
       DataSourceSelectArguments a=new DataSourceSelectArguments();
       SqlDataSource1.Select(a);gridview.datasource=sqldatasource1;  // 改為gridview.datasourceId="sqldatasource1"
gridview.databind();這裏gridview為什麽不顯示出數據啊??我直接放在sql裏查詢,能查出數據的

Answer 1

没见过这种用法……干嘛不按正规方法查询数据绑定DATATABLE啊或者DATASET啊什么的啊……

Answer 2

有没有给SqlDataSource控件设置ConnectionString属性

Answer 3

你照着线面试试~~<asp:GridView ID="ListGrid" BorderWidth="0px" AutoGenerateColumns="False" DataKeyNames="ListId"
 DataSourceID="ListDataSource" AllowPaging="True" AllowSorting="True" EnableViewState="False"
GridLines="None" runat="server">
<Columns>

</Columns>

</asp:GridView>
<asp:SqlDataSource ID="ListDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SimpleListsConnectionString %>"
        SelectCommand=
        UpdateCommand=
        DeleteCommand=
</asp:SqlDataSource>

Answer 4

DataSourceID="ListDataSource"
是必须得。
ConnectionString="<%$ ConnectionStrings:SimpleListsConnectionString %>"中的SimpleListsConnectionString是在WebConfig中的数据库连接。
必须得。

Answer 5

当然，这里要说明下：
用gridview.datasource赋值，那么一般不用SqlDataSource。用SqlDataSource（DataSourceID="ListDataSource"），的话就不用gridview.datasource。两者不能共存，会报错。