前台代码:
DSP <asp:dropdownlist id="cboDSP" runat="server" AutoPostBack="True" SelectedIndexChanged ="cboDSP_SelectedIndexChanged" ></asp:dropdownlist>
后台代码:
Sub cboDSP_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboDSP.SelectedIndexChanged
Dim strsql As String
Dim cn As New SqlClient.SqlConnection()
cn = obj.get_cn()
cn.Open()
'strsql = "select ds_code from t_dsp with (nolock) order by ds_code"
strsql = "select DC_TRANSFER_CODE from t_dsp inner join T_DSP_CITY on ds_code=dc_dsp with (nolock) order by ds_code where ds_code=" & "'" & cboDSP.SelectedItem.Value.ToString & "'"
obj.bind_dropdownlist(strsql, ddl_transfer_to, "DC_TRANSFER_CODE", "DC_TRANSFER_CODE", cn)
End Sub
我在SelectIndexChange事件设了断点,操作,发现没有执行到事件里面,怎么回事呢?
DSP <asp:dropdownlist id="cboDSP" runat="server" AutoPostBack="True" SelectedIndexChanged ="cboDSP_SelectedIndexChanged" ></asp:dropdownlist>
后台代码:
Sub cboDSP_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboDSP.SelectedIndexChanged
Dim strsql As String
Dim cn As New SqlClient.SqlConnection()
cn = obj.get_cn()
cn.Open()
'strsql = "select ds_code from t_dsp with (nolock) order by ds_code"
strsql = "select DC_TRANSFER_CODE from t_dsp inner join T_DSP_CITY on ds_code=dc_dsp with (nolock) order by ds_code where ds_code=" & "'" & cboDSP.SelectedItem.Value.ToString & "'"
obj.bind_dropdownlist(strsql, ddl_transfer_to, "DC_TRANSFER_CODE", "DC_TRANSFER_CODE", cn)
End Sub
我在SelectIndexChange事件设了断点,操作,发现没有执行到事件里面,怎么回事呢?
解决方案 »
- 纠结
- 分不多,求一个关于insert into的sql语句。
- Gridview实现多列排序并显示图标
- datagrid控件点编辑之后再点删除时绑定在删除按钮上的onclick事件中的confirm对话框就不弹出是怎么回事
- 求小于65535的正则表达式,急~
- 寻:远程投审稿系统
- 请问如何给RadioButtonList绑定数据?
- 救急:为什么我安装了Visual Studio.NET 2003后系统总提示错误?
- 如何把aspx页面动态生成静态页面呀 好想大网站都是这么做的!
- 救急!!html页面改为aspx后,如何进行对页面上的控件编程?
- 用Application+Session弄得聊天室怎么实现无刷新提交信息
- js中怎么传多个数组到mvc控制台中
<asp:button runat="server" text="Button" ID="btdrop" OnClick="btdrop_click" style="display:none;" />
<script>function selectDrop(obj){document.getElementById("<%=btdrop.ClientID%>").click();}</script>
这样来实现。
或者用JQ来实现无刷新。
因为你用页回发后,提交数据就会有问题了。所以不建议用SelectedIndexChanged 来实现数据绑定。
在你的dropdownList的selectIndexChange事件加入Label1.Text=strsql.ToString();
看看你的脚本有没问题