how to retrive sql data very fast using asp.net with vb.net

Question

stellusm...

SOLVED CLOSED ACTIVE ANSWERED
User: stellusmca
Posted: on Feb 10, 2016 11:56 PM
Forum: Data Controls
Answer: 1
Views: 3700

Dear ALL,
i have one douts about my application.
this application i was developed by asp.net with vb.net.
my problem is,

i am trying to show my sql table data(ex: table name=test) into my web page.
and moreover in my table i have 2000 rows.
meanwhile i want to show all the rows where in that table on my web page.

But the problem is,
i displayed 2000 rows on my web page but its displaying too late which means after one minute only i got the result.
this is my problem.
Note : but if i have show just 20 rows then it will come very fast but 2000 rows will not.

please find my below source code and let me know where i made the mistake.

<b>design page: sample.aspx</b>

<pre lang="C#">&lt;script type=&quot;text/javascript&quot; language=&quot;javascript&quot;&gt;
		
	
		// ======================== //
		// ===&gt; Get Menu Items &lt;=== //
		// ======================== //
		
		function GetMenuItems()
		{  
		   try
		    {    
		     
			if (xmlHttp.readyState==4)	
			{
			
				if (xmlHttp.status==200)
				{
				     
                    loggeduser=document.getElementById(&quot;hdnuser&quot;).value;
                    modefop=document.getElementById(&quot;hdnmode&quot;).value;  
                    ValUser = document.getElementById(&quot;ValUser&quot;).value ;
      
					var XmlData=xmlHttp.responseText;
					
					if(XmlData.substring(0,1)==&quot;&lt;&quot;)
					{
					    if (isShopaid==0)
					    {
					   
					         ApplicationMenus.XMLDocument.loadXML(XmlData);
					        
//					         ShowMenuPermision(isShopaid);
					         //document.getElementById(&quot;tabs1&quot;).style.display=&quot;inline&quot;;
					         }
					
					}
					else
					    throw &quot;Invalid Xml&quot;
				
						if(isShopaid==0 &amp;&amp; ApplicationMenus.xml !=  &quot;&quot;)
						 BuildApplicationMenus(isShopaid);	
					
					//}
					  // if(isShopaid!=1)
						LoadReportMenuItems(isShopaid);
						
					
					document.getElementById(&quot;divProcess&quot;).style.visibility = &quot;hidden&quot;;	
					 ShowMenuPermision(isShopaid);
				}
				else
				{
				    HandleAjaxError(xmlHttp,&#39;divProcess&#39;);
				}
			}
			}
		    catch (e)
		    {
		    ShowScriptError(e,&quot;GetMenuItems&quot;);
		    }
		}
	
		
		// ===================================================== //
		// ===&gt; Build Application Menu Items in a Tree View &lt;=== //
		// ===================================================== //
		
		function BuildApplicationMenus(id)
		{
		 try
		    {
			var Html = &quot;&lt;Table Id = &#39;Menu&#39;&quot;+id+&quot; Border=0 class=&#39;sfont&#39;&gt;&quot;
			
			// =================== //
			// ===&gt; Main Menu &lt;=== //
			// =================== //
			for(var Row = 0; Row &lt; ApplicationMenus.XMLDocument.documentElement.childNodes.length; Row++)
			{
				if(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[2].nodeValue == 0)
				{
					if(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[3].nodeValue = -1)
					{
				
				      if(AllowRep == 1 &amp;&amp; modefop == &quot;Add&quot; ) 
				           Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;img id=img&quot;+ id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot; src=&#39;../images/plus.gif&#39;  onclick=show(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;) style=&#39;cursor:hand;&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39; disabled=&#39;disabled&#39; id=&#39;chk&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) +&quot;&#39; onclick=CheckAll(&#39;tbl&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
					  else 
					      Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;img id=img&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot; src=&#39;../images/plus.gif&#39;  onclick=show(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;) style=&#39;cursor:hand;&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39;  id=&#39;chk&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) +&quot;&#39; onclick=CheckAll(&#39;tbl&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
					    
					    
					    Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;Table class=&#39;sfont&#39; id = &#39;tbl&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; style = display:none Border=0&gt;&quot;
						
						// ========================= //
						// ===&gt; SubMenu Level 0 &lt;=== //
						// ========================= //
						
						for(var SubRow = 0; SubRow &lt; ApplicationMenus.XMLDocument.documentElement.childNodes.length; SubRow++)
						{
							if(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[2].nodeValue == ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue)
							{
								if((ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[3].nodeValue == &quot;True&quot;) || (ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[3].nodeValue == 1))
								{
								   if(AllowRep == 1 &amp;&amp; modefop == &quot;Add&quot; ) 
								     	Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;img id=img&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot; src=&#39;../images/plus.gif&#39;  onclick=show(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;) style=&#39;cursor:hand;&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39; disabled=&#39;disabled&#39; id=&#39;chk&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckAll(&#39;tbl&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;);CheckParent(&#39;&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&#39;,&#39;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
								    else
									   Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;img id=img&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot; src=&#39;../images/plus.gif&#39;  onclick=show(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;) style=&#39;cursor:hand;&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39;  id=&#39;chk&quot; +id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckAll(&#39;tbl&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;);CheckParent(&#39;&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&#39;,&#39;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
									
									
									Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;Table class=&#39;sfont&#39; id = &#39;tbl&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; style = display:none Border=0&gt;&quot;
									
									// ========================= //
									// ===&gt; SubMenu Level 1 &lt;=== //
									// ========================= //
									
									for(var SubRow1 = 0; SubRow1 &lt; ApplicationMenus.XMLDocument.documentElement.childNodes.length; SubRow1++)
									{
										if(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[2].nodeValue == ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue)
										{
											if((ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[3].nodeValue == &quot;True&quot;) || (ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[3].nodeValue == 1))
											{
											    if(AllowRep == 1 &amp;&amp; modefop == &quot;Add&quot; ) 
											     
												  Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;img id=img&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot; src=&#39;../images/plus.gif&#39;  onclick=show(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;) style=&#39;cursor:hand;&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39; disabled=&#39;disabled&#39; id=&#39;chk&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckAll(&#39;tbl&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;);CheckParent(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
												 else
												  Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;img id=img&quot; +id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot; src=&#39;../images/plus.gif&#39;  onclick=show(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;) style=&#39;cursor:hand;&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39; id=&#39;chk&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckAll(&#39;tbl&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;);CheckParent(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
												 
												Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;Table class=&#39;sfont&#39; id = &#39;tbl&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; style = display:none&gt;&quot;
												
												// ========================= //
												// ===&gt; SubMenu Level 2 &lt;=== //
												// ========================= //
												
												for(var SubRow2 = 0; SubRow2 &lt; ApplicationMenus.XMLDocument.documentElement.childNodes.length; SubRow2++)
												{
													if(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow2].attributes[2].nodeValue == ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue)
													{
													  if(AllowRep == 1 &amp;&amp; modefop == &quot;Add&quot; ) 
													   	  Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39; disabled=&#39;disabled&#39; id=&#39;chk&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow2].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckParent(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow2].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
													   else 
													      Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39;  id=&#39;chk&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow2].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckParent(&#39;&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow2].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
													  
													}
												}
												Html += &quot;&lt;/Table&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;
											}
											else
											{
											  if(AllowRep == 1 &amp;&amp; modefop == &quot;Add&quot; ) 
											    	Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;img src=&#39;../images/transparent.gif&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39; disabled=&#39;disabled&#39; id=&#39;chk&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckParent(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
											  else
											        Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;img src=&#39;../images/transparent.gif&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39;  id=&#39;chk&quot; +id+ replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckParent(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&quot; + id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow1].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
											 
										}
									}
								  }
									Html += &quot;&lt;/Table&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;
								}
								else
								{
								if(AllowRep == 1 &amp;&amp; modefop == &quot;Add&quot; ) 
								    Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;img src=&#39;../images/transparent.gif&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39; disabled=&#39;disabled&#39; id=&#39;chk&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckParent(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&#39;,&#39;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
								  else  
								 	Html += &quot;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;Td&gt;&lt;img src=&#39;../images/transparent.gif&#39;&gt;&lt;/Td&gt;&lt;Td&gt;&lt;input type=&#39;checkbox&#39;  id=&#39;chk&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39; onclick=CheckParent(&#39;&quot;+id + replaceAll(ApplicationMenus.XMLDocument.documentElement.childNodes[Row].attributes[0].nodeValue,&quot; &quot;,&quot;&quot;) + &quot;&#39;,&#39;&#39;,&#39;&#39;)&gt;&amp;nbsp;&quot; + ApplicationMenus.XMLDocument.documentElement.childNodes[SubRow].attributes[1].nodeValue + &quot;&lt;/Td&gt;&lt;/Tr&gt;&lt;Tr&gt;&lt;Td&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;;
								  
								}
							}
						}
						Html += &quot;&lt;/Table&gt;&lt;/Td&gt;&lt;/Tr&gt;&quot;
					}
				}
			}
			Html += &quot;\n&lt;/Table&gt;&quot;;
			document.getElementById(&quot;divAppMenus&quot;+isShopaid).innerHTML = Html;
		  }
		  catch (e)
		    {
		    ShowScriptError(e,&quot;BuildApplicationMenus(id)&quot;);
		    }
		};
		
		
		
		
		
		// ========================================= //
		// ===&gt; Replace strA with strb in text  &lt;=== //
		// ========================================= //
		
		function replaceAll(text, strA, strB) 
		{
		 try
		  {
			while(text.indexOf(strA) != -1)
			{
				text = text.replace(strA,strB);
			}
			return text;
		  }
           catch (e)
           {
            ShowScriptError(e, &quot;replaceAll(text, strA, strB)&quot;);		        
           }
		}
		
	
		
		// ======================================== //
		// ===&gt; Selection Changed in Drop Down &lt;=== //
		// ======================================== //
		
		function SelectionChanged(isSelected) 
		{
		  try
		    {
		          if(isSelected==1)
		          {
		            document.getElementById(&quot;divAppMenus0&quot;).innerHTML=&quot;&quot;;
		            document.getElementById(&quot;divAppMenus1&quot;).innerHTML=&quot;&quot;;
		          }
		            
		            loggeduser=document.getElementById(&quot;hdnuser&quot;).value;
		            ValUser = document.getElementById(&quot;ValUser&quot;).value ;
                    modefop=document.getElementById(&quot;hdnmode&quot;).value;  

			      
			      if(document.getElementById(&quot;cmbGroupName&quot;).options[document.getElementById(&quot;cmbGroupName&quot;).value].text != &quot;Select GroupName&quot;)
			       {
			    
				        var t = new Date();
				        LogInUser = document.getElementById(&quot;hdnuser&quot;).value;
			            document.getElementById(&quot;divProcess&quot;).style.visibility=&quot;visible&quot;;	    
				        xmlHttp = new ActiveXobject(&quot;Microsoft.XMLHTTP&quot;);
				        xmlHttp.onreadystatechange=GetMenuItems;
				       // xmlHttp.open(&#39;POST&#39;, &#39;../masterutil/GetMasterGroup.aspx?User=&#39; + document.getElementById(&quot;cmbGroupName&quot;).options[document.getElementById(&quot;cmbGroupName&quot;).value].text + &quot;&amp;t=&quot; + t + &quot;&amp;LogInUser=&quot;+ LogInUser + &quot;&amp;ReqMode=&quot;+ isShopaid, true);
				        xmlHttp.open(&#39;POST&#39;, &#39;../masterutil/test.aspx?User=&#39; + document.getElementById(&quot;cmbGroupName&quot;).options[document.getElementById(&quot;cmbGroupName&quot;).value].text + &quot;&amp;t=&quot; + t + &quot;&amp;LogInUser=&quot;+ LogInUser + &quot;&amp;ReqMode=&quot;+ isShopaid, true);
				        var strxml=&quot;SelectionChangeApp_&quot; + document.getElementById(&quot;cmbGroupName&quot;).options[document.getElementById(&quot;cmbGroupName&quot;).value].text;
				        xmlHttp.send(strxml);
		           }
		     }
		//  }
          catch (e)
          {
            ShowScriptError(e, &quot;SelectionChanged(isSelected)&quot;);		        
          }
		   
		
		};
		
	

    &lt;/script&gt;</pre>

     <select class="tBox" id="cmbGroupName" style="width: 183px;" onchange="SelectionChanged(1);"
            name="cmbGroupName" runat="server">
            <option value="0" selected>Select GroupName</option>
        </select>

<b>code behind page: page name test.aspx.vb</b>



Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        If Not Helper.IsValidSession(Request, Application) Then
            'Response.Write(Helper.Message4InvalidSession)
            Response.Write("Session Expired")
            ' GoTo resEnd
            ' Response.End()
            'Exit Sub
        End If

        Dim R As StreamReader
        Dim xmlString As String
        Dim ClientData As String
        Dim Result As String = ""
        Dim LogInUser As String

        Try
            usernm = "Admin"
            lgusr = Request.QueryString("lguser")
            LogInUser = Request.QueryString("LogInUser")

            If Not Request.QueryString("ReqMode") Is Nothing Then
                ReqMode = Request.QueryString("ReqMode")
            End If

            '==================================
            '===> Loading Data from Client <===
            '==================================
            Usr = Request.QueryString("User")

            getdt = Format(Helper.GetDateTime(), "yyyy-MM-dd hh:MM:ss")
            Userby = LogInUser


            R = New StreamReader(Request.InputStream)
            ClientData = R.ReadToEnd
            R.Close()

            '=========================
            '===> Open Connection <===
            '=========================
            Con = Helper.GetConnection
            If Con.State <> ConnectionState.Open Then
                Con.Open()
            End If


            ' ElseIf ClientData.Substring(0, 18) = "SelectionChangeApp" Then
            If ClientData.Substring(0, 18) = "SelectionChangeApp" Then
                '====================================================
                '===> Gets All Application Menus with Permission <===
                '====================================================
                Dim ClientDataArr As String()
                Dim AppPermissions As DataTable
                Dim UG As UserGroup

                '===================================
                '===> Get All Application Menus <===
                '===================================
                MenuItems = MasterHelper.GetMenuKeyTable(Con, ReqMode)
                ' MenuItems = MasterHelper.GetMenuKeyTable(Con)

                '==================================================
                '===> Gets Application Menus for the UserGroup <===
                '==================================================
                ClientDataArr = Split(ClientData, "_")
                UG = New UserGroup("GroupName = '" & ClientDataArr(1) & "'", Con)

                If UG.Permission = "" Then
                    UG.Permission = "0"
                End If
                If ReqMode = 0 Then
                    AppPermissions = UG.GetAppMenuPermissions()
                ElseIf ReqMode = 1 Then
                    AppPermissions = UG.GetAppMenuPermissions4Shopaid()
                End If


                '=======================================================
                '===> Creates Application Menu Xml with Permissions <===
                '=======================================================
                Menu = New XmlDocument
                Menu.LoadXml("<Menu></Menu>")

                For Each DR In MenuItems.Rows
                    SubMenu = Menu.CreateElement("SubMenu")
                    SubMenu.SetAttribute("MenuID", DR("MenuID"))
                    SubMenu.SetAttribute("Caption", Replace(DR("Caption"), "&", ""))
                    SubMenu.SetAttribute("ParentID", DR("ParentID"))
                    SubMenu.SetAttribute("HasChild", DR("HasChild"))
                    If AppPermissions.Select("MenuID = " + DR("MenuID").ToString + "").Length > 0 Then
                        SubMenu.SetAttribute("Checked", 1)
                    Else
                        SubMenu.SetAttribute("Checked", 0)
                    End If

                    Menu.DocumentElement.AppendChild(SubMenu)
                Next

                Result = Menu.OuterXml

            Else
                Result = "Invalid Mode"
            End If

   
        Catch Ex As Exception
            Result = Helper.FormatErrorMessage(Ex, ErrorMsgFormat.WindowFormat)
        Finally
            If Not Con Is Nothing Then Con.Close()
        End Try
        Response.Write(Result)

        Response.End()

    End Sub
 


thanks to all.

how to retrive sql data very fast using asp.net with vb.net

Company

Explore

Follow us

Contact Us