如何使用ajaxtoolkit传递参数SQL查询 [英] How to pass parameter SQL query with ajaxtoolkit

问题描述

我有一个可编辑的ajaxtoolkit

它的工作完全没有参数SQL查询



我想使用一个参数从另一个ajaxtoolkit控件调用



我需要你帮助我，如何在Ajax中传递参数？



我的尝试：

< form id =form1runat =server> 
< asp：ScriptManager ID =ScriptManager1runat =server/> 
< div> 
< div class =col-md-12> 
< ajaxToolkit：ComboBox ID =CmbCountryAppendDataBoundItems =True
 runat =serverAutoCompleteMode =SuggestDataSourceID =SqlDataSource1
 DataTextField =CountryDataValueField =国家MaxLength =0Style =left：auto; top：auto;> 
< / ajaxToolkit：ComboBox> 
< asp：SqlDataSource ID =SqlDataSource1runat =server
 ConnectionString =<％$ ConnectionStrings：cs％> 
 SelectCommand =从[StateMaster]中选择不同的国家>< / asp：SqlDataSource> 
< / div> 
< div class =col-md-12> 
< ajaxToolkit：ComboBox ID =ComboBox1
 AppendDataBoundItems =Truerunat =serverAutoCompleteMode =Suggest
 DataSourceID =SqlDataSource2DataTextField =State
 DataValueField =State
 MaxLength =0Style =left：auto; top：auto;> 
< / ajaxToolkit：ComboBox> 
< asp：SqlDataSource ID =SqlDataSource2runat =server
 ConnectionString =<％$ ConnectionStrings：cs％> 
 SelectCommand =从[statemaster]中选择不同的状态，其中[Country] = @ Country> 
< SelectParameters> 
< asp：ControlParameter ControlID =cmbCountryName =CountryPropertyName =SelectedValueType =StringDefaultValue =Country/> 
< / SelectParameters> 
< / asp：SqlDataSource> 
 
< / div> 
< div class =col-md-12> 
< ajaxToolkit：ComboBox ID =ComboBox2AppendDataBoundItems =True
 runat =serverAutoCompleteMode =Suggest
 DataSourceID =SqlDataSource3DataTextField =State
 DataValueField =StateMaxLength =0Style =left：auto; top：auto;> 
< / ajaxToolkit：ComboBox> 
< asp：SqlDataSource ID =SqlDataSource3
 runat =serverConnectionString =<％$ ConnectionStrings：cs％> 
 SelectCommand =选择不同的城市来自[StateMaster]，其中[State = @State]> 
< SelectParameters> 
< asp：ControlParameter ControlID =ComboBox1Name =StatePropertyName =SelectedValueType =String/> 
< / SelectParameters> 
< / asp：SqlDataSource> 
< / div> 
 
< / div> 
 
 
< / form> 

解决方案

ConnectionStrings：cs％>
SelectCommand =从[StateMaster]中选择不同的国家>< / asp：SqlDataSource>
< / div>
< div class =col-md-12>
< ajaxToolkit：ComboBox ID =ComboBox1
AppendDataBoundItems =Truerunat =serverAutoCompleteMode =Suggest
DataSourceID =SqlDataSource2DataTextField =State
DataValueField =State
MaxLength =0Style =left：auto; top：auto;>
< / ajaxToolkit：ComboBox>
< asp：SqlDataSource ID =SqlDataSource2runat =server
ConnectionString =<％

ConnectionStrings：cs％>
SelectCommand =从[statemaster]中选择不同的状态，其中[Country] = @ Country>
< SelectParameters>
< asp：ControlParameter ControlID =cmbCountryName =CountryPropertyName =SelectedValueType =StringDefaultValue =Country/>
< / SelectParameters>
< / asp：SqlDataSource>

< / div>
< div class =col-md-12>
< ajaxToolkit：ComboBox ID =ComboBox2AppendDataBoundItems =True
runat =serverAutoCompleteMode =Suggest
DataSourceID =SqlDataSource3DataTextF ield =State
DataValueField =StateMaxLength =0Style =left：auto; top：auto;>
< / ajaxToolkit：ComboBox>
< asp：SqlDataSource ID =SqlDataSource3
runat =serverConnectionString =<％

ConnectionStrings：cs％>
SelectCommand =SELECT distinct City FROM [StateMaster] where [State = @ State]>
< SelectParameters>
< asp：ControlParameter ControlID =ComboBox1Name =StatePropertyName =SelectedValueType =String/>
< / SelectParameters>
< / asp：SqlDataSource>
< / div>

< / div>


< / form>

I have a Editable ajaxtoolkit
its works perfectly fine with the no parameter SQL query

I want to use a parameter that has been called from another ajaxtoolkit control

I need you to help me , how pass parameter in Ajax ?

What I have tried:

<form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
    <div >
        <div class="col-md-12">
                <ajaxToolkit:ComboBox ID="CmbCountry"  AppendDataBoundItems="True" 
                    runat="server" AutoCompleteMode="Suggest" DataSourceID="SqlDataSource1" 
                    DataTextField="Country" DataValueField="Country" MaxLength="0" Style="left: auto; top: auto;">
                </ajaxToolkit:ComboBox>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:cs %>" 
                    SelectCommand="SELECT distinct Country from [StateMaster]"></asp:SqlDataSource>
        </div>
        <div class="col-md-12">
                <ajaxToolkit:ComboBox ID="ComboBox1"  
                    AppendDataBoundItems="True" runat="server" AutoCompleteMode="Suggest" 
                    DataSourceID="SqlDataSource2" DataTextField="State" 
                    DataValueField="State" 
                    MaxLength="0" Style="left: auto; top: auto;">
                </ajaxToolkit:ComboBox>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:cs %>" 
                    SelectCommand="SELECT distinct State from [statemaster] where [Country]=@Country">
                    <SelectParameters>
                 <asp:ControlParameter ControlID="cmbCountry" Name="Country" PropertyName="SelectedValue" Type="String" DefaultValue="Country" />
                                        </SelectParameters>
                </asp:SqlDataSource>
            
        </div>
        <div class="col-md-12">
                <ajaxToolkit:ComboBox ID="ComboBox2"  AppendDataBoundItems="True" 
                    runat="server" AutoCompleteMode="Suggest" 
                    DataSourceID="SqlDataSource3" DataTextField="State" 
                    DataValueField="State" MaxLength="0" Style="left: auto; top: auto;">
                </ajaxToolkit:ComboBox>
                <asp:SqlDataSource ID="SqlDataSource3" 
                    runat="server" ConnectionString="<%$ ConnectionStrings:cs %>" 
                    SelectCommand="SELECT distinct City FROM [StateMaster] where [State =@State]">
                    <SelectParameters>
                 <asp:ControlParameter ControlID="ComboBox1" Name="State" PropertyName="SelectedValue" Type="String" />
                                        </SelectParameters>
                </asp:SqlDataSource>
        </div>

    </div>
  
    
    </form>

解决方案

ConnectionStrings:cs %>" SelectCommand="SELECT distinct Country from [StateMaster]"></asp:SqlDataSource> </div> <div class="col-md-12"> <ajaxToolkit:ComboBox ID="ComboBox1" AppendDataBoundItems="True" runat="server" AutoCompleteMode="Suggest" DataSourceID="SqlDataSource2" DataTextField="State" DataValueField="State" MaxLength="0" Style="left: auto; top: auto;"> </ajaxToolkit:ComboBox> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%

ConnectionStrings:cs %>" SelectCommand="SELECT distinct State from [statemaster] where [Country]=@Country"> <SelectParameters> <asp:ControlParameter ControlID="cmbCountry" Name="Country" PropertyName="SelectedValue" Type="String" DefaultValue="Country" /> </SelectParameters> </asp:SqlDataSource> </div> <div class="col-md-12"> <ajaxToolkit:ComboBox ID="ComboBox2" AppendDataBoundItems="True" runat="server" AutoCompleteMode="Suggest" DataSourceID="SqlDataSource3" DataTextField="State" DataValueField="State" MaxLength="0" Style="left: auto; top: auto;"> </ajaxToolkit:ComboBox> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%

ConnectionStrings:cs %>" SelectCommand="SELECT distinct City FROM [StateMaster] where [State =@State]"> <SelectParameters> <asp:ControlParameter ControlID="ComboBox1" Name="State" PropertyName="SelectedValue" Type="String" /> </SelectParameters> </asp:SqlDataSource> </div> </div> </form>

这篇关于如何使用ajaxtoolkit传递参数SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！