Cascading dropdown asp.net Part 22

[@georgigeorgiev4871]

Amazing, very well detailed and explained tutorial. Great job!

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you kzbin.infoplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat

[@Csharp-video-tutorialsBlogspot]

To receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. May I ask you for a favour. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video.

[@Csharp-video-tutorialsBlogspot]

Here is the order 1. C# 2. Dot Net Basics 3. SQL Server 4. ADO.NET 5. ASP.NET 6. GridView tutorial 7. MVC

[@w.kooratv6717]

Great and Greatness 💜💜

[@krismaly6300]

Clear and Crisply explained Cascading Drop Down Lists. I recommend others to watch. Thanks a lot

[@debojyotichatterjee2845]

I absolutely loved this one!! I had already identified the problem you mentioned from 30:01. I figured it out myself and while doing that I thought I will comment about that here, but by the end of the video the I see that you took care of the problem of selecting the previous DropDownList option. However I need to see how I can refactor and reduce this code though. Really a great help! Moving on to the next video!!

[@sharvaryrane1702]

Ur just "The" best.... U explain so much in detail... Great job.. Worth watching your videos and learning in details...

[@rifaqatullah2379]

Sir you deserve billion likes...thumb up

[@MrJohn2475]

thank you, life saver for a new C# student!

[@Fkn1405]

Wow... This tutorial still very much valid in 2020. Thank you very much Venkat for such passion and hard work. Watching from South Africa

[@Ayubajbnabi]

Thanks allot for these very useful easy to understand and precise tutorials. Heart prays for you. Thanks.

[@mguyf_artwork5864]

Many thanks to your work👌🙏🙏I respect, God bless you 🙏.

[@Csharp-video-tutorialsBlogspot]

I understand, you might have checked this already, but just to make sure, have you verified if for any of the dropdownlist, DataSourceID property is specified. Please note that we are specifying DataSource dynamically in code and hence DataSourceID property in the HTML is not required. Hope this solves the issue you have. Please let me know how it goes. Good Luck.

[@programmerrafik]

you are professional =D and your vidio is very comprehensive videos thanx alot

[@AlexMartinez-be2rh]

Exactly that the way that make programms in my company, Thanks a lot for this tutorials.

[@jamalfaiye5464]

Thanks Venkat You are the man :)

[@Levi-qy2yb]

Thank you man this is very useful tutorial for me. And also i am learning coding from you.

[@Dannydhanny]

Superb Venkat Garu!!!

[@vaibhavtrikolikar4902]

Thank you so much sir for another great Video..!

[@behnamsafari4978]

Great job with great details thanks

[@ramyamusuku2022]

Excellent..Very well explained..Thank you for such wonderful explanation

[@rhchino123]

Mr. Venkat where can i donate some money for u ? omg u r so good

[@aamirjamal6833]

I switch my adBlocker off while watching his videos only because he is worth it..

[@Trzbne]

Me too, just watched an Udemi ad, but please visit www.pragimtech.com/support.aspx - aspx, if you know, what I mean :DD

[@Csharp-video-tutorialsBlogspot]

Hi Abhi, check if the values for the first dropdownlist are being loaded in the Page_Load() event. Please check if you are doing the load in (!IsPostback) condition. I think this is what is the issue. If not please share your code. Good Luck. If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.

[@devangkamdar7574]

Very well explained the complicated topic "Cascading Dropdown" Also choose smarter way when creating GetData()

[@Aritro92]

Super. explained in detail.

[@oraksoft7471]

oh man U saved me .Thankyouuuuuuuuuuuuuuuu.

[@ivumm]

Muy muy bueno. Bien explicado. Felicidades!!

[@deepthitulasi13]

Hi Venkat! Thank you for the wonderful videos. I have a issue in vb, my page has 5 cas dd n btn to filter. When i select one dd the other needs to be refreshed,that fine. The issue is I am using updatepanel to display results in gridview. So the refreshing of dd is taking long time depending on gridview results. If the results displayed are long then refreshing of dropdowns is long too..if its short then the refresh is short. I want the grid and dropdowns seperated.

[@sarathchandra941]

thank u very much... for such a valuable information and marvelous explanation

[@mouradbarakat123]

Great presentation. Thank You!

[@PaaruRetheesh]

Hello Venkat Thank you for your awsome tutorials...!!! I am a Computer Science graduate. Whn srchng jobs the main problm I am facing is the lack of hands on exp. So I am requesting you pls post video tutorials of small projects that make use of .net platform HTML XML CSS and ofcourse dont forget about the MVC technology. Try to incorporate all the technologies you discussed in diff video tutorials. If you do so it will be very very helpfull for people like me to try developing our own projects

[@Devilnero1991]

Very helpful, god bless you sir.

[@reshmisumanth1675]

Excellent teaching ... thanks alot

[@RashidAli-tx3vm]

Much appreciated work mate.

[@pavan1910]

Superb and Elegant..!!

[@krismaly]

Dear KV, You were taliking on Refacoring in video "Cascading dropdown asp.net Part 22 ". Is there anyway you could make a video on Refacoring for the same video. I think this kind of scenarios are frequesntly used in the industry. I hope your Refactoring video would help many including me. I have lots of appreciation for you.

[@kipropeddie4254]

great video, your work is awesome

[@maiwanduniversity478]

Very Good Thanks

[@MiddleEasternInAmerica]

great effort, clear explanation I love your videos so much my brother hope you record some videos about design pattern and code re-factoring.

[@shashb3194]

really awesome sir

[@sharmilamohan3882]

Clear Explanation tutorial. Understood many concepts from all of your videos. Could u please upload videos on crystal reports? Thanku ... Here some videos are little bit blur.

[@jamoimccleary3664]

Amazing video. Really helped

[@Csharp-video-tutorialsBlogspot]

Try removing the DatasourceID attribute and it should work as expected.

[@jayan4657]

Sir ur tutorials are very useful,, thanks alot for this type of services

[@DaviKobi]

Hi Venkat Thanks for this great tutorials, keep up the good work. Is there any chance that this video can be performed only on client side without posting back to server each time?

[@moorwahdan]

Very organized, thank you very much

[@Cougarbite]

Good work!

[@bebek8989]

great explanation venkatt

[@juliobarriga]

Great stuff.

[@SiyamandRashid]

thanks for all the efforts and good videos ; i have one question if you dont mind , i followed along the video , but when i select an item form first dropdown list ... it filters the 2nd dropdown list , without showing Select City text, and its not in the list , i have the code as belwo : public partial class Admin_test : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { ddlMake.DataSource = GetData("SP_ddlMake", null); ddlMake.DataBind(); ListItem liMake = new ListItem("Select make", "-1"); ddlMake.Items.Insert(0, liMake); ListItem liModel = new ListItem("Select Model", "-1"); ddlModel.Items.Insert(0, liModel); ddlModel.Enabled = false; } } private DataSet GetData(string SPName, SqlParameter SPParameter) { string cs = ConfigurationManager.ConnectionStrings["Test_Connection"].ConnectionString; SqlConnection con = new SqlConnection(cs); SqlDataAdapter sda = new SqlDataAdapter(SPName, con); sda.SelectCommand.CommandType = CommandType.StoredProcedure; if(SPParameter != null) { sda.SelectCommand.Parameters.Add(SPParameter); } DataSet DS = new DataSet(); sda.Fill(DS); return DS; } protected void ddlMake_SelectedIndexChanged(object sender, EventArgs e) { if (ddlMake.SelectedIndex ==0) { } else { ddlModel.Enabled = true; SqlParameter ddlModelParameter = new SqlParameter("@Make_ID", ddlMake.SelectedValue); DataSet ds = GetData("SP_ddlModel", ddlModelParameter ); ddlModel.DataSource = ds; ddlModel.DataBind(); } } }

[@RowanGontier]

Excellent tutorial.

[@CodeRealtime]

Hi Venkat first thanks for uploading video lectures .. i am facing a problem while selecting data from dropdown .. dropdown is selecting only the first index 0 value .. and when i am selecting the other values .. it again sets the values to the first index 0 value.... conclusion not been able to select the other values . and yes i am performing cascading and fetching data from Database .

[@rishabhagrawal1431]

Awesome Video

[@CodeRealtime]

Thank's .. but if it is possible can you please give us a demo on this problem through a video lecture and yes i had already subscribed to your channel long back .

[@franksolomon5805]

Venkat, this vid like all the others = awesome stuff. Thanks so much! Suggestion: at about 8:30, you split off the data handling into private method DataSet. Before I got this specific ASP.net app working (I follow along w/the vid and change things to learn more) the DataSet method crashed. A lot. I found that try / catch / finally would help here. In the "catch" block, maybe have an error msg but definitely have return null; and in the finally block, have con.Close(); - Frank

[@zk850715]

Hi Venkat, How can I select text when I use data bind dropdown list? Thanks.

[@sridharramachandran3835]

Thanks Venkat

[@hlams2]

yea i find that i had writen in specified datasourceID. these videous is very usefull for begginer like me

[@MegaSwarn]

how to populate textbox value based on dropdown selection? I have created a stored procedure but not able to get the value in the textbox.

[@khajaaleem5927]

Hi sir, i am getting confused which series to learn first either c#,asp.net,ado.net or mvc,please reply me what to start with in order please reply soon.

[@12345678958200]

C# asp.net ado.net mvc

[@sushantsahay4576]

great

[@niteshsingh5236]

Thank you so much

[@hlams2]

i have error when trying to start page it says that. Both DataSource and DataSourceID are defined on 'DropDownList1'. Remove one definition. how to solve it?

[@ianmk4306]

hi tech i want to find the DB that you use it in your tutorial can u support the link of the DB like continenttable and the other ones that use it in all your tutorials please

[@bebek8989]

hi usama visit here for the code csharp-video-tutorials.blogspot.com/2012/11/cascading-dropdown-in-aspnet-part-22.html

[@luigel]

kudvenkat sir do we need to have an ID for each column?

[@AnalyticalJha]

Hello Sir, These videos are very helpful. thanks a lot. Please let me know if Cascading dropdown is possible by using SqlDataReader Instead of SqlDataAdapter. If yes please help how can i do the same. thanks in advance.

[@kavithasaphal]

thank u so much..

[@prettycolddeath]

sir, firstly ur adorable. u really make me understand asp.net and i could fast upgrade myself to .net from asp classic. btw, i think u missed something in this session. when u select continent > country > city and select back any continent, u must disable selecting city and set SelectedIndex to 0. btw, i watched it again and noticed i missed it. u duplicate //ddlCities.SelectedIndex = 0; //ddlCities.Enabled = false; twice. as; if (selectedIndex == 0) and else. and im sure u know that u didnt need to do that like this=)

[@afghanboy4022]

Hello sir ! first I am thankful of your videos in asp and also I have subscribed your channel and fan of you your video lectures. Sir I have a question in control of asp.net , dropdownlist control, and my question is this: Whenever if we have a dropdown of 100 elements it is not a good way to display them all coz it will generate a dropdown list with a not friendly view. I want display only 10 or 15 in drop down and rest all in scroll of the drop downlist and I really don’t know how to handle that I researched too many sites but still I am stuck and don’t know how to handle it. Plz sir show me a way to solve this issue or some referrals to solve this issue I have a final year project I am really needy of dropdownlist. Thans in advance! Mohammad Hanif from Afghanistan

[@shalinisoni1088]

According to this method we can store a values of records ....🤔in database ..what we do when we want to store text in database

[@mehtarahul1419891]

could you tell how it can be done graphically..

[@MunamYousuf]

Just a little confusion. in GetData method you didn't open or close the connection. Why is it so. Didn't we expect connection to be open before performing database operations.

[@bumblebee2012able]

+Munam Yousuf SqlDataAdapter doesn't need to open and close connection

[@MrShahjaha]

hii sir, u uploaded a nice series, but there is some missing video. could u upload it again please. and could u upload video on LINQ Technique. thanks in advance.

[@dhanashrigurav4980]

Why error comes to da.fill (DS) -it says databse with the same name exist or specified file cannot be opened..plz help..i m new for asp.net

[@alirezakaveh8430]

where is the con.open()? why you did not open connection in the defined method?

[@sukhbawa1976]

Sir, Your tutorial are very helpful. Please let me know is any DVD of tutorials are available in market.

[@Csharp-video-tutorialsBlogspot]

Hi, yes we do provide DVD as well. For more details, please contact us on [e-mail]

[@raphaelbernard7954]

Vankat How do we open this from IIS as tut 82-84? Is it possible? Thank you.

[@kidsfan6464]

Sir am facing error declar variable value

[@rajeshwar2261]

Could u pls tell me How r getting intellisence in MySQL Server like Ms Visual Stdio

[@shahbazjutt8353]

Sir One question

[@gtrj55tgjr]

hello sir my question is why you use stored procedure because this also done without store procedure i have made this code where i have changed to "TRUE" the Autopostback of DropDownList2 only not DropDownList1 and its work great as like yours.. namespace Tutorial1 { public partial class DropDown : System.Web.UI.Page { public String myStateId; SqlConnection conn = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\MyDatabase.mdf;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlCommand comm = new SqlCommand("Select StateId,State from State", conn); conn.Open(); DropDownList2.DataSource=comm.ExecuteReader(); DropDownList2.DataTextField = "State"; DropDownList2.DataValueField = "State"; DropDownList2.DataBind(); } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { Response.Write(DropDownList1.Text); } protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { myStateId =DropDownList2.Text; SqlCommand comm = new SqlCommand("Select City,CityId from City where State='"+myStateId+"'", conn); conn.Open(); DropDownList1.DataSource = comm.ExecuteReader(); DropDownList1.DataTextField = "City"; DropDownList1.DataValueField = "CityId"; DropDownList1.DataBind(); } } }

[@haiderali-fu8pe]

I need sql ddl scripts for these tables? can you upload them?

[@bebek8989]

haider ali visit csharp-video-tutorials.blogspot.com/2012/11/cascading-dropdown-in-aspnet-part-22.html for the code

[@johnnydepp1499]

+bbeek lapan Thanks dude. :)

[@musashuaibu5198]

C# cascading drop down list store only ids in the database

[@tourwithamol]

Dear Sir, Thanks so much for providing such a great efforts by you..I really appreciate your great work. I am getting following error , kindly suggest me the solution for the same.. Error description: Server Error in '/' Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not load type 'test.CascadingDropownList'. Source Error: Line 1: Line 2: Line 3: Source File: /CascadingDropownList.aspx Line: 1