August 30, 2008 03:29am 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.0, 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... 271,975
2. Dhaest 126,082
3. jaime_oliv... 117,871
4. jcoehoorn 94,057
5. naspinski 76,640
6. emoreau 71,225
7. GreenGho... 66,010
8. jpaulino 64,570
9. raterus 63,050
10. samtran0... 61,295
11. Velio 53,140
12. ZachSmith 46,850
13. angelIII 46,138
14. avnish_t... 44,550
15. tedbilly 43,814
16. graye 43,235
17. webtubbs 41,160
18. VBRocks 40,000
19. prairiedog 39,700
20. pratima_... 38,979
21. Idle_Mind 37,825
22. JimBrandley 35,360
23. Sancler 35,250
24. ororiole 33,355
25. surajguptha 33,250

1. TheLearn... 638,353
2. samtran0... 240,610
3. Dhaest 211,605
4. surajguptha 200,972
5. jaime_oliv... 195,956
6. Idle_Mind 165,095
7. emoreau 140,360
8. jcoehoorn 112,357
9. jpaulino 102,400
10. JimBrandley 101,222
11. Fernando... 98,534
12. McExp 89,513
13. DarkoLord 88,876
14. graye 88,549
15. GreenGho... 87,260
16. angelIII 85,042
17. VBRocks 82,820
18. webtubbs 80,960
19. tedbilly 78,414
20. Sancler 77,532
21. naspinski 76,640
22. raterus 75,425
23. TSmooth 72,363
24. pratima_... 62,329
25. PaulHews 60,148

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

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

Tags: Microsoft, C#

About this solution