October 6, 2008 03:01pm pdt

04.29.2008 at 04:18PM PDT, ID: 23363966

	[x] Attachment Details

Working with SQLDATASOURCE Select Parameters ASP.NET C# Grird View

Asked by sonu19 in .NET Framework 2.x, C# Programming Language, Microsoft Visual C#.Net

Tags: Microsoft, C#

Hey Guys,

I am working with Select Parameters on the .Net C# Griview.

As you can see in the code below, I am selecting from the database by passing Model and Make to the database.
What I want to do it when a user select all for the model I dont want to query with model because I will be selecting all the cars with that make.

How can I achieve this .

Thanks
Start Free Trial

         
             <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings: GrooveCar %>"
                    SelectCommand="SELECT *,Manufacturers.mfgName as Make,dealers.companyname as companyname FROM usedcars left join Manufacturers on Manufacturers.mfgid=usedcars.mfgid left join dealers on dealers.dealerid = usedcars.dealerid where usedcars.active=1 and usedcars.mfgid=@makeid and usedcars.vindecodemodel=@model order by carid desc " >
                    <SelectParameters>
                   
                    <asp:QueryStringParameter Name="makeid" QueryStringField="makeid" />
                    <asp:QueryStringParameter Name="model" QueryStringField="model" />
                    </SelectParameters>
                </asp:SqlDataSource>

Keywords: Working with SQLDATASOURCE Sele…

	Title
1	Sending parameters to a Data Web Par…
2	SQLDATASOURCE
3	Integer List parameters in a SqlDataSo…
4	sqldatasource
5	Assistance required with creating a w…
6	sqldatasource querystring parameter

Loading Advertisement...

20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628

1. TheLearn... 284,098
2. jaime_oliv... 133,623
3. Dhaest 132,796
4. jcoehoorn 97,057
5. jpaulino 83,670
6. naspinski 78,240
7. emoreau 77,569
8. raterus 67,050
9. GreenGho... 66,010
10. samtran0... 65,295
11. avnish_t... 59,550
12. graye 53,735
13. Velio 53,140
14. angelIII 50,638
15. tedbilly 50,614
16. VBRocks 49,680
17. ZachSmith 46,850
18. webtubbs 46,660
19. Idle_Mind 45,975
20. prairiedog 44,750
21. ororiole 40,205
22. Fernando... 40,020
23. pratima_... 38,979
24. JimBrandley 37,360
25. rachitkohli 35,600

1. TheLearn... 650,476
2. samtran0... 244,610
3. Dhaest 218,319
4. jaime_oliv... 211,708
5. surajguptha 201,972
6. Idle_Mind 173,245
7. emoreau 146,704
8. jpaulino 121,500
9. jcoehoorn 115,357
10. Fernando... 105,534
11. JimBrandley 103,222
12. graye 99,049
13. VBRocks 92,500
14. DarkoLord 90,476
15. angelIII 89,542
16. McExp 89,513
17. GreenGho... 87,260
18. webtubbs 86,460
19. tedbilly 85,214
20. raterus 79,425
21. naspinski 78,240
22. Sancler 77,532
23. TSmooth 72,363
24. pratima_... 62,329
25. sammy1... 61,400

Working with SQLDATASOURCE Select Parameters ASP.NET C# Grird View

Asked by sonu19 in .NET Framework 2.x, C# Programming Language, Microsoft Visual C#.Net

Tags: Microsoft, C#

About this solution