DropDownListのOnSelectedIndexChangedで、ListViewに表示する内容を変えたく
下記のようにしているのですが、drp_tanto.SelectedValue == ""の時は
きちんとデータが表示されるのですが、値が入っているのを選択すると
「データは返されませんでした。」となってしまいます。
SQL自体は問題なく、正常に取得できていることは確認致しました。
ですが、OnItemDataBoundイベントにも入ってきていません。
また、いろいろと検索してみて、接続文字列に Allow User Variables=Trueを
加えてみたのですが、System.Data.Dllでエラーとなり、
KeyWord not supportedとなってしまいます。
private void drp_chanege_handler(){
string sql = "";
sql = "SELECT m.item as item,m.lot as lot";
sql += ",m.itemgroup as itemgroup";
sql += ",m.user_id as user_id";
sql += ",m.login_name as login_name";
sql += ",m.updateday as updateday";
sql += ",m.createday as createday";
sql += ",m.sort_id as sort_id";
sql += ",(CASE WHEN t.price1 is NULL THEN 0 ELSE t.price1 END) as price1";
sql += ",(CASE WHEN t.price2 is NULL THEN 0 ELSE t.price2 END) as price2";
if (drp_tanto.SelectedValue == "")
{
sql += " FROM (SELECT * FROM m_syouhin ) m LEFT JOIN ";
sql += " (SELECT * FROM tbl_priceset where setday='" + prv_date.ToString("yyyy/MM/dd") + "') t ";
}
else
{
sql += " FROM (SELECT * FROM m_syouhin where login_name='" + drp_tanto.SelectedValue + "' ) m LEFT JOIN ";
sql += " (SELECT * FROM tbl_priceset where setday='" + prv_date.ToString("yyyy/MM/dd") + "') t ";
}
sql += " ON m.item=t.item and m.lot=t.lot order by m.sort_id,m.item,m.lot";
MySqlDataSource.SelectCommand = sql;
}
<label>担当名</label>
<asp:DropDownList ID="drp_tanto" runat="server" AutoPostBack="True" OnSelectedIndexChanged="drp_tanto_SelectedIndexChanged" class="form-control"></asp:DropDownList>
<asp:ListView ID="_listView" runat="server" DataSourceID="MySqlDataSource" DataKeyNames="item,lot" OnItemDataBound="_listView_ItemDataBound" OnLayoutCreated="_listView_LayoutCreated">
<EmptyDataTemplate>
<table id="Table1" runat="server" style="">
<tr>
<td>データは返されませんでした。</td>
</tr>
</table>
</EmptyDataTemplate>
<ItemTemplate>
<tr>
<td class="c1">
<a href="#" data-toggle="modal" data-target="#basicModal" class="btn btn-success">行挿入</a>
</td>
<td class="c2">
<asp:Label Text='<%# Eval("sort_id") %>' runat="server" ID="sortLabel" />
</td>
<td class="c3">
<asp:Label Text='<%# Eval("item") %>' runat="server" ID="itemLabel" />
</td>
<td class="c4">
<asp:Label Text='<%# Eval("lot") %>' runat="server" ID="lotLabel" />
</td>
</tr>
</ItemTemplate>
<LayoutTemplate>
<table border="0" class="table table-bordered table-hover table-striped table-hgroup overflow-y">
<thead class="scrollHead">
<tr runat="server" style="">
<th runat="server"></th>
<th runat="server"></th>
<th runat="server"></th>
<th runat="server"></th>
</tr>
<tr runat="server" style="">
<th runat="server" class="c1"></th>
<th runat="server" class="c2">表示順</th>
<th runat="server" class="c3">商品</th>
<th runat="server" class="c4">規格</th>
</tr>
</thead>
<tbody class="scrollBody">
<asp:PlaceHolder runat="server" ID="itemPlaceholder" />
</tbody>
</table>
</LayoutTemplate>
<SelectedItemTemplate>
<tr>
<td class="c1">
<a href="#" data-toggle="modal" data-target="#basicModal" class="btn btn-lg btn-success">行挿入</a>
</td>
<td class="c2">
<asp:Label Text='<%# Eval("sort_id") %>' runat="server" ID="sortLabel" />
</td>
<td class="c3">
<asp:Label Text='<%# Eval("item") %>' runat="server" ID="itemLabel" />
</td>
<td class="c4">
<asp:Label Text='<%# Eval("lot") %>' runat="server" ID="lotLabel" />
</td>
</tr>
</SelectedItemTemplate>
</asp:ListView>
<asp:SqlDataSource ID="MySqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:MySqlDataSorce %>"
ProviderName="<%$ ConnectionStrings:MySqlDataSorce.ProviderName %>"
SelectCommand="SELECT m.item as item,m.lot as lot,m.itemgroup as itemgroup,m.user_id as user_id,m.login_name as login_name,m.updateday as updateday,m.createday as createday,t.price1 as price1,t.price2 as price2,m.sort_id as sort_id FROM m_syouhin m ,tbl_priceset t where m.item=t.item and m.lot=t.lot order by m.sort_id,m.item,m.lot"
InsertCommand="INSERT into m_syouhin (item, lot,itemgroup,user_id,login_name,updateday,createday,sort_id ) values (@item,@lot,@itemgroup,@user_id,@login_name,@updateday,@createday,@sort_id )"
OnInserting="MySqlDataSource_Inserting"></asp:SqlDataSource>
-----------------------------------------------------------------
開発用PC
Windows8 Pro、VsiaulStudio Commity2013
(ASP.net C#)
ASP.NET開発サーバ、IIS8、Framework4.5
MySQL Server 5.6、MySQL Connector Net
6.6.5
-------------------------------------------------------------------
