使用列表框从多个表中选择的项目从数据库检索数据.当我们从列表框选择服务名称时，其他文本框值从sql server中检索并显示在文本框上... [英] retreive data from database using listbox selected item from multiple table.when we select service name from list box other text box values r retrieve from sql server and display on textboxes...

问题描述

添加订单

< form id ="form1" name ="form1" method ="post" action ="> bgcolor =#e9e9e9" style =高度:258px；宽度:97％"> < asp:标签ID ="lblClient" runat =服务器" Text =客户端名称"> < asp:ListBox ID ="ListBox1" runat ="server" DataSourceID ="SqlDataSource1" DataTextField ="Client_Name" DataValueField ="Client_Name" Width ="165px" 高度="34px" onselectedindexchanged ="btnSave_Click"> < asp:SqlDataSource ID ="SqlDataSource1" runat =服务器" ConnectionString =<％$ ConnectionStrings:WebMantra_databaseConnectionString％>" SelectCommand ="SELECT [Client_Name] FROM [AddClient]"> < asp:RequiredFieldValidator ID ="RequiredFieldValidator1" runat =服务器" ErrorMessage =选择客户端" ForeColor ="Red" ControlToValidate ="ListBox1"> < asp:标签ID ="lblService" runat =服务器" Text =服务> < label>  < asp:ListBox ID ="ListBox2" runat ="server" DataSourceID ="SqlDataSource2" DataTextField ="Service_Name" DataValueField ="Service_Name" Width ="157px" Height ="32px" SelectionMode ="Multiple" onselectedindexchanged ="ListBox2_SelectedIndexChanged"> < asp:SqlDataSource ID ="SqlDataSource2" runat =服务器" ConnectionString =<％$ ConnectionStrings:WebMantra_databaseConnectionString10％>" SelectCommand ="SELECT [Service_Name] FROM [AddServices]"> < asp:RequiredFieldValidator ID ="RequiredFieldValidator2" runat =服务器" ErrorMessage =选择服务" ForeColor ="Red" ControlToValidate ="ListBox2"> </label> < asp:标签ID ="Label1" runat =服务器" Text =服务>  详细信息 < label>  < asp:文本框 ID ="TextBox1" runat =服务器" Text =''<％#Eval("Contact_Person")％>'' ondatabinding ="ListBox2_SelectedIndexChanged" ondisposed ="btnReset_Click" onload ="ListBox2_SelectedIndexChanged" ontextchanged ="ListBox2_SelectedIndexChanged" onunload ="btnReset_Click"> </label> 价格 Text =''<％#Eval("Contact_Person")％>'' ontextchanged ="ListBox2_SelectedIndexChanged"> </label> 联系人 </label> 电子邮件ID </label> < asp:标签ID ="lblTerm" runat =服务器" ForeColor =#FF3300"> 条款及细则条件 < asp:CheckBox ID ="CheckBox1" runat ="server" Text =条款和条件"/> < label>  </label>   onclick ="btnSave_Click" style ="width:42px"/> < label>   < asp:按钮ID ="btnReset" runat =服务器" Text =重置" BackColor =#99CC00" onclick ="btnReset_Click"宽度="50px"/> </label> </form>

Add Orders

<form id="form1" name="form1" method="post" action=""> bgcolor="#e9e9e9" style="height: 258px; width: 97%"> <asp:Label ID="lblClient" runat="server" Text="Client Name"> <asp:ListBox ID="ListBox1" runat="server" DataSourceID="SqlDataSource1" DataTextField="Client_Name" DataValueField="Client_Name" Width="165px" Height="34px" onselectedindexchanged="btnSave_Click"> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:WebMantra_databaseConnectionString %>" SelectCommand="SELECT [Client_Name] FROM [AddClient]"> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Select Client" ForeColor="Red" ControlToValidate="ListBox1"> <asp:Label ID="lblService" runat="server" Text="Service"> <label>  <asp:ListBox ID="ListBox2" runat="server" DataSourceID="SqlDataSource2" DataTextField="Service_Name" DataValueField="Service_Name" Width="157px" Height="32px" SelectionMode="Multiple" onselectedindexchanged="ListBox2_SelectedIndexChanged"> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:WebMantra_databaseConnectionString10 %>" SelectCommand="SELECT [Service_Name] FROM [AddServices]"> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="Select Service" ForeColor="Red" ControlToValidate="ListBox2"> </label> <asp:Label ID="Label1" runat="server" Text="Service">  detail <label>  <asp:TextBox ID="TextBox1" runat="server" Text=''<%#Eval("Contact_Person") %>'' ondatabinding="ListBox2_SelectedIndexChanged" ondisposed="btnReset_Click" onload="ListBox2_SelectedIndexChanged" ontextchanged="ListBox2_SelectedIndexChanged" onunload="btnReset_Click"> </label> Price <label>  <asp:TextBox ID="TextBox2" runat="server" Text=''<%#Eval("Contact_Person") %>'' ontextchanged="ListBox2_SelectedIndexChanged"> </label> Contact Person <label>  <asp:TextBox ID="TextBox3" runat="server" Text=''<%#Eval("Contact_Person") %>''> </label> Email Id <label>  <asp:TextBox ID="TextBox4" runat="server" Text=''<%#Eval("Contact_Person") %>''> </label> <asp:Label ID="lblTerm" runat="server" ForeColor="#FF3300"> Terms & Conditions <asp:CheckBox ID="CheckBox1" runat="server" Text="terms and condition" /> <label>  </label>   <asp:Button ID="btnSave" runat="server" Text="Save" BackColor="#99CC00" onclick="btnSave_Click" style="width: 42px" /> <label>   <asp:Button ID="btnReset" runat="server" Text="Reset" BackColor="#99CC00" onclick="btnReset_Click" Width="50px" /> </label> </form>

推荐答案

ConnectionStrings:WebMantra_databaseConnectionString％>"
SelectCommand ="SELECT [Client_Name] FROM [AddClient]">
< asp:RequiredFieldValidator ID ="RequiredFieldValidator1" runat =服务器"
ErrorMessage =选择客户端" ForeColor ="Red" ControlToValidate ="ListBox1">
< asp:标签ID ="lblService" runat =服务器" Text =服务> < label>
 < asp:ListBox ID ="ListBox2" runat ="server" DataSourceID ="SqlDataSource2"
DataTextField ="Service_Name" DataValueField ="Service_Name" Width ="157px"
Height ="32px" SelectionMode ="Multiple"
onselectedindexchanged ="ListBox2_SelectedIndexChanged">

< asp:SqlDataSource ID ="SqlDataSource2" runat =服务器"
ConnectionString =<％

ConnectionStrings:WebMantra_databaseConnectionString %>"
SelectCommand="SELECT [Client_Name] FROM [AddClient]">
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ErrorMessage="Select Client" ForeColor="Red" ControlToValidate="ListBox1">
<asp:Label ID="lblService" runat="server" Text="Service"> <label>
 <asp:ListBox ID="ListBox2" runat="server" DataSourceID="SqlDataSource2"
DataTextField="Service_Name" DataValueField="Service_Name" Width="157px"
Height="32px" SelectionMode="Multiple"
onselectedindexchanged="ListBox2_SelectedIndexChanged">

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%

ConnectionStrings:WebMantra_databaseConnectionString10％>"
SelectCommand ="SELECT [Service_Name] FROM [AddServices]">

< asp:RequiredFieldValidator ID ="RequiredFieldValidator2" runat =服务器"
ErrorMessage =选择服务" ForeColor ="Red" ControlToValidate ="ListBox2">
</label>
< asp:标签ID ="Label1" runat =服务器" Text =服务>  详细信息 < label>
 < asp:文本框
ID ="TextBox1" runat =服务器" Text =''<％#Eval("Contact_Person")％>''
ondatabinding ="ListBox2_SelectedIndexChanged" ondisposed ="btnReset_Click"
onload ="ListBox2_SelectedIndexChanged"
ontextchanged ="ListBox2_SelectedIndexChanged" onunload ="btnReset_Click">
</label>
价格 Text =''<％#Eval("Contact_Person")％>''
ontextchanged ="ListBox2_SelectedIndexChanged">
</label>
联系人 </label>
电子邮件ID </label>

< asp:标签ID ="lblTerm" runat =服务器" ForeColor =#FF3300">
条款及细则条件 < asp:CheckBox ID ="CheckBox1" runat ="server" Text =条款和条件"/>
< label>
 </label>   onclick ="btnSave_Click" style ="width:42px"/>
< label>
 
< asp:按钮ID ="btnReset" runat =服务器" Text =重置" BackColor =#99CC00"
onclick ="btnReset_Click"宽度="50px"/>
</label>
</form>

ConnectionStrings:WebMantra_databaseConnectionString10 %>"
SelectCommand="SELECT [Service_Name] FROM [AddServices]">

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ErrorMessage="Select Service" ForeColor="Red" ControlToValidate="ListBox2">
</label>
<asp:Label ID="Label1" runat="server" Text="Service">  detail <label>
 <asp:TextBox
ID="TextBox1" runat="server" Text=''<%#Eval("Contact_Person") %>''
ondatabinding="ListBox2_SelectedIndexChanged" ondisposed="btnReset_Click"
onload="ListBox2_SelectedIndexChanged"
ontextchanged="ListBox2_SelectedIndexChanged" onunload="btnReset_Click">
</label>
Price <label>
 <asp:TextBox ID="TextBox2" runat="server"
Text=''<%#Eval("Contact_Person") %>''
ontextchanged="ListBox2_SelectedIndexChanged">
</label>
Contact Person <label>
 <asp:TextBox ID="TextBox3" runat="server" Text=''<%#Eval("Contact_Person") %>''>
</label>
Email Id <label>
 <asp:TextBox ID="TextBox4" runat="server" Text=''<%#Eval("Contact_Person") %>''>
</label>

<asp:Label ID="lblTerm" runat="server" ForeColor="#FF3300">
Terms & Conditions <asp:CheckBox ID="CheckBox1" runat="server" Text="terms and condition" />
<label>
 </label>   <asp:Button ID="btnSave" runat="server" Text="Save" BackColor="#99CC00"
onclick="btnSave_Click" style="width: 42px" />
<label>
 
<asp:Button ID="btnReset" runat="server" Text="Reset" BackColor="#99CC00"
onclick="btnReset_Click" Width="50px" />
</label>
</form>

这篇关于使用列表框从多个表中选择的项目从数据库检索数据.当我们从列表框选择服务名称时，其他文本框值从sql server中检索并显示在文本框上...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！