带jQuery的Asp.net [英] Asp.net with jquery

问题描述

受保护的无效btnFirsEvent_Click(对象发送者，EventArgs e)
   {
       整数m = 20;
       SqlConnection objConnection =新的SqlConnection(@数据源= STANZOO-FE82BEA \ SQLEXPRESS;初始目录= stanzoo；集成安全性= True")；
       SqlDataAdapter objdata = new SqlDataAdapter(从类别类似'" + hdntxtcategories.Value.ToString()+％'"，objConnection的项目中选择不同的categoryid，类别)；
       SqlDataAdapter objdata1 =新的SqlDataAdapter(选择前10个子类别，从子类别(例如'" + hdntxtcategories.Value.ToString()+％'"，objConnection)的项目中选择子类别)；
       DataSet objdataset =新的DataSet();
       DataSet objdataset1 =新的DataSet();
       objdata.Fill(objdataset，"Categories");
       objdata1.Fill(objdataset1，"SubCategories");
       字符串ConstructTable ="表 边界  ='  1'   单元格填充  ='  5'   单元格间距  ='  5'   高度  ='  150px' > ;
       ConstructTable + =" tr  <   td    样式  ='  vertical-align:top' > ;
       ConstructTable + =" div   id   ='  s'   样式  ='  background-color:red; width:150px; align:center' >  Categories ><  /div  > ;
       for(int i = 0; i <     objdataset. Tables [0] .Rows.Count;     i ++) 
                     span>  { 
 
                     span>       //  int     s   =   0;
 
                     span>       //s ++;  
                     span>        HiddenField1.Value   =   objdataset.Tables [0] .Rows.Count.ToString();
 
                     span>        constructTable   +   ="     +      +  ")' >  <     ='  "+ i +"' > "+ objdataset.Tables [0] .Rows [i] [类别"] +"/div  <   > ";
       }
       ConstructTable + ="/td  <   td    样式  ='  vertical-align:top' > ;
       ConstructTable + =" div  样式  ='  background-color:red; width:150px; align:center' > 子类别<  > ";
       for(int i = 0; i <     objdataset1. Tables [0] .Rows.Count;     i ++) 
                     span>  { 
 
                     span>        HiddenField2.Value   =   objdataset1.Tables [0] .Rows.Count.ToString();
 
                     span>        constructTable   +   ="   
 span>  +     m     +    "   样式  ='  cursor:hand'    onclick   ='  javascript:ShowSubcategory("+ objdataset1.Tables [0]. Rows [i] ["subcategoryid"].ToString()+)' /div  /td  <  /tr  >  <  /table  > ;
       divTable.InnerHtml =构造表;
       //txtCategories.Focus();
       //System.Text.StringBuilder sb = new System.Text.StringBuilder();
       //sb.Append("<  脚本   语言  ='  javascript' > )；
       //sb.Append("var text = document.getElementById(');
       //sb.Append("txtCategories);
       //sb.Append(');");
       //sb.Append("text.focus();");
       //sb.Append("text.value=text.value;);
       //Page.RegisterStartupScript("FocusScript，sb.ToString());
       //text1.focus();
       //alert("hi");
       //text1.value = text1.value;
   }
   受保护的无效btnIds_Click(对象发送者，EventArgs e)
   {
       按钮btnId =(按钮)发送器;
       SqlConnection objConnection =新的SqlConnection(@数据源= STANZOO-FE82BEA \ SQLEXPRESS;初始目录= stanzoo；集成安全性= True")；
     SqlDataAdapter objdata;
     DataSet ds = new DataSet(); ;
       开关(btnId.ID.ToLower())
       {
           案例"btnids":
               objdata = new SqlDataAdapter(从categoryid =" + hdnids.Value +"，objConnection的项目中选择*)；
               objdata.Fill(ds，"asd1");
               txtCategories.Text = ds.Tables [0] .Rows [0] ["category"].ToString();
               休息;
           案例"btnsubcategory":
               objdata = new SqlDataAdapter("select * from subcategoryid =" + hdnids.Value +"，objConnection的项目)；
               objdata.Fill(ds，"asd");
               txtCategories.Text = ds.Tables [0] .Rows [0] ["subcategory"].ToString();
               休息;
       } 

 $(function(){
            如果($(' #txtCategories' ).val()== " ){
                $(' #divTable').css('  display'，'  none');
            }
            $(' #Text3').keydown(function(){
            });
            $(' #txtCategories').keyup(function(e){
                 var  myLength = $(" ).val().length;
                $(' #divTable').css('  display'，'  block');
                $(' #hdntxtcategories').val($( ' #txtCategories').val());
//  if(myLength == 1){
                $(' #btnFireEvent').click();
// } 
            });
        });
        函数ShowCategory(category){
            $(' #hdnids').val(category);
            $(' #btnIds').click();

        }
        函数ShowSubcategory(SubCategory){
            $(' #hdnids').val(SubCategory);
            $(' #btnSubcategory').click();

        } 

解决方案

(function(){ 如果(

(' " "){

(' #divTable').css(' display'，' protected void btnFirsEvent_Click(object sender, EventArgs e) { int m = 20; SqlConnection objConnection = new SqlConnection(@"Data Source=STANZOO-FE82BEA\SQLEXPRESS;Initial Catalog=stanzoo;Integrated Security=True"); SqlDataAdapter objdata = new SqlDataAdapter("select distinct categoryid,category from items where category like '" + hdntxtcategories.Value.ToString() + "%'", objConnection); SqlDataAdapter objdata1 = new SqlDataAdapter("select Top 10 subcategoryid,subcategory from items where subcategory like '" + hdntxtcategories.Value.ToString() + "%'", objConnection); DataSet objdataset = new DataSet(); DataSet objdataset1 = new DataSet(); objdata.Fill(objdataset, "Categories"); objdata1.Fill(objdataset1, "SubCategories"); string constructTable = "<table border='1' cellpadding='5' cellspacing='5' height='150px'>"; constructTable += "<tr><td style='vertical-align:top'>"; constructTable += "<div id='s' style='background-color:red;width:150px;align:center'>Categories</div>"; for (int i = 0; i < objdataset.Tables[0].Rows.Count; i++) { // int s=0; //s++; HiddenField1.Value = objdataset.Tables[0].Rows.Count.ToString(); constructTable += "<a style='cursor:pointer'; onclick='javascript:ShowCategory(" + objdataset.Tables[0].Rows[i]["categoryid"].ToString() + ")'><div id='" + i + "'>" + objdataset.Tables[0].Rows[i]["category"] + "</div></a>"; } constructTable += "</td><td style='vertical-align:top'>"; constructTable += "<div style='background-color:red;width:150px;align:center'>Sub Categories</div>"; for (int i = 0; i < objdataset1.Tables[0].Rows.Count; i++) { HiddenField2.Value = objdataset1.Tables[0].Rows.Count.ToString(); constructTable += "<div id=" + m + " style='cursor:hand' onclick='javascript:ShowSubcategory(" + objdataset1.Tables[0].Rows[i]["subcategoryid"].ToString() + ")'>" + objdataset1.Tables[0].Rows[i]["subcategory"] + "</div>"; m++; } constructTable += "</td></tr></table>"; divTable.InnerHtml = constructTable; //txtCategories.Focus(); //System.Text.StringBuilder sb = new System.Text.StringBuilder(); //sb.Append("<script language='javascript'>"); //sb.Append("var text=document.getElementById('"); //sb.Append("txtCategories"); //sb.Append("');"); //sb.Append("text.focus();"); //sb.Append("text.value=text.value;"); //Page.RegisterStartupScript("FocusScript", sb.ToString()); //text1.focus(); //alert("hi"); //text1.value = text1.value; } protected void btnIds_Click(object sender, EventArgs e) { Button btnId = (Button)sender; SqlConnection objConnection = new SqlConnection(@"Data Source=STANZOO-FE82BEA\SQLEXPRESS;Initial Catalog=stanzoo;Integrated Security=True"); SqlDataAdapter objdata; DataSet ds = new DataSet(); ; switch (btnId.ID.ToLower()) { case "btnids": objdata = new SqlDataAdapter("select * from items where categoryid=" + hdnids.Value + "", objConnection); objdata.Fill(ds,"asd1"); txtCategories.Text = ds.Tables[0].Rows[0]["category"].ToString(); break; case "btnsubcategory": objdata = new SqlDataAdapter("select * from items where subcategoryid=" + hdnids.Value + "", objConnection); objdata.Fill(ds, "asd"); txtCategories.Text = ds.Tables[0].Rows[0]["subcategory"].ToString(); break; }

$(function() {
            if ($('#txtCategories').val() == "") {
                $('#divTable').css('display', 'none');
            }
            $('#Text3').keydown(function() {
            });
            $('#txtCategories').keyup(function(e) {
                var myLength = $("#txtCategories").val().length;
                $('#divTable').css('display', 'block');
                $('#hdntxtcategories').val($('#txtCategories').val());
//                if (myLength == 1) {
                $('#btnFireEvent').click();
//                }
            });
        });
        function ShowCategory(category) {
            $('#hdnids').val(category);
            $('#btnIds').click();

        }
        function ShowSubcategory(SubCategory) {
            $('#hdnids').val(SubCategory);
            $('#btnSubcategory').click();

        }

解决方案

(function() { if (

('#txtCategories').val() == "") {

('#divTable').css('display', 'none'); }

这篇关于带jQuery的Asp.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！