; GridView Filtering with DropDownList Or Textbox In ASP.NET Without Any Code(VB.Net \ C#.Net) | SQL Server

Big Entertainment On Demand

Best Streaming TV Online  - Visit Here

GridView Filtering with DropDownList Or Textbox In ASP.NET Without Any Code(VB.Net \ C#.Net)


Know More :  ASP.Net  VB.Net  C#.Net  Sliverlight  XML  WPF  WCF Ajax
Let’s start with visual studio 2010\2008\2005\2003. ScreenShot050




Go to file menu and select new website as shown in figure..
ScreenShot051
Next..ScreenShot052
If you select your web location “HTTP” then use this step – by- step as shown in figure..
ScreenShot053
Next..
ScreenShot054
After your web form is open like this..ScreenShot056
Select design mode as shown in figure..
image
 Now in design mode,  drag  DropDownList, Textbox, GridView, also two SqlDataSource controls from toolbox as shown in figure..
ScreenShot055
Now Configure SqlDataSource1 as shown in figure..







Select your database connection if you have already created.
 
Or use new sql connection.After click  new connection ' add connection form open' like this use step shown in figure.
After connection created. Now data binding DropDownList  control like this ..
ScreenShot058 ScreenShot061
After binding DropDownList control , Now Configure SqlDataSource2 control for GridView, for filtering with DropDownList Or Textbox control as shown in figure…
ScreenShot062
ScreenShot063 ScreenShot064
After click on Ok button, Now binding GridView control with SqlDataSource2 like this.
ScreenShot065 ScreenShot066
After binding , Now start debugging from debug menu or press f5  button, After debug your application  shown in figure ……
ScreenShot067
After click on Ok button your output like this in browser…
ScreenShot068
After select Employee Id from DropDownList , change the value in Gridview and also you can use textbox control like DropDownList control. Thanks.
Know More :  ASP.Net  VB.Net  C#.Net  Sliverlight  XML  WPF  WCF Ajax
Share on Google Plus

About Sujay Sharma

Hi ! I am Sujay Sharma. I am working in Indian Railway as Guard. I am sharing my experience about Microsoft SQL Server with ASP.NET ,VB.NET,C#.NET,XML "" Thanks.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment