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 ua-cam.com/users/kudvenkatplaylists?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. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ua-cam.com/users/kudvenkat 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
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!!
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.
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.
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
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.
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.
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.
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?
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
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.
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 .
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 .
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=)
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
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(); } } }
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.
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.
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
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.
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?
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.
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(); } } }
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
Amazing, very well detailed and explained tutorial. Great job!
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
ua-cam.com/users/kudvenkatplaylists?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.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-cam.com/users/kudvenkat
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
Clear and Crisply explained Cascading Drop Down Lists.
I recommend others to watch.
Thanks a lot
Sir you deserve billion likes...thumb up
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!!
Here is the order
1. C#
2. Dot Net Basics
3. SQL Server
4. ADO.NET
5. ASP.NET
6. GridView tutorial
7. MVC
Great and Greatness 💜💜
Ur just "The" best.... U explain so much in detail... Great job.. Worth watching your videos and learning in details...
thank you, life saver for a new C# student!
Superb Venkat Garu!!!
Many thanks to your work👌🙏🙏I respect, God bless you 🙏.
Wow... This tutorial still very much valid in 2020. Thank you very much Venkat for such passion and hard work. Watching from South Africa
Great job with great details thanks
Thanks allot for these very useful easy to understand and precise tutorials. Heart prays for you. Thanks.
you are professional =D and your vidio is very comprehensive videos thanx alot
Thank you so much sir for another great Video..!
Thanks Venkat
You are the man :)
Exactly that the way that make programms in my company, Thanks a lot for this tutorials.
Excellent..Very well explained..Thank you for such wonderful explanation
Super. explained in detail.
Muy muy bueno. Bien explicado. Felicidades!!
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.
Superb and Elegant..!!
Thank you man this is very useful tutorial for me. And also i am learning coding from you.
Great stuff.
really awesome sir
oh man U saved me .Thankyouuuuuuuuuuuuuuuu.
great video, your work is awesome
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.
Very helpful, god bless you sir.
Excellent teaching ... thanks alot
Very Good Thanks
thank u very much... for such a valuable information and marvelous explanation
Much appreciated work mate.
Mr. Venkat where can i donate some money for u ? omg u r so good
I switch my adBlocker off while watching his videos only because he is worth it..
Me too, just watched an Udemi ad, but please visit www.pragimtech.com/support.aspx - aspx, if you know, what I mean :DD
great explanation venkatt
Very well explained the complicated topic "Cascading Dropdown"
Also choose smarter way when creating GetData()
Awesome Video
Great presentation. Thank You!
Amazing video. Really helped
great effort, clear explanation
I love your videos so much my brother
hope you record some videos about design pattern and code re-factoring.
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
Good work!
Excellent tutorial.
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.
Very organized, thank you very much
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.
Sir ur tutorials are very useful,, thanks alot for this type of services
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.
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?
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
Try removing the DatasourceID attribute and it should work as expected.
Thanks Venkat
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.
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 .
great
yea i find that i had writen in specified datasourceID. these videous is very usefull for begginer like me
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 .
Thank you so much
thank u so much..
Hi Venkat,
How can I select text when I use data bind dropdown list? Thanks.
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=)
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
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();
}
}
}
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.
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.
C# asp.net ado.net mvc
kudvenkat sir do we need to have an ID for each column?
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.
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
hi usama visit here for the code csharp-video-tutorials.blogspot.com/2012/11/cascading-dropdown-in-aspnet-part-22.html
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.
Sir,
Your tutorial are very helpful. Please let me know is any DVD of tutorials are available in market.
Hi, yes we do provide DVD as well. For more details, please contact us on kudvenkat@gmail.com
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?
could you tell how it can be done graphically..
where is the con.open()? why you did not open connection in the defined method?
Sir am facing error declar variable value
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.
+Munam Yousuf SqlDataAdapter doesn't need to open and close connection
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
Vankat How do we open this from IIS as tut 82-84? Is it possible? Thank you.
Sir One question
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();
}
}
}
Could u pls tell me How r getting intellisence in MySQL Server like Ms Visual Stdio
According to this method we can store a values of records ....🤔in database ..what we do when we want to store text in database
I need sql ddl scripts for these tables? can you upload them?
haider ali visit csharp-video-tutorials.blogspot.com/2012/11/cascading-dropdown-in-aspnet-part-22.html for the code
+bbeek lapan Thanks dude. :)
C# cascading drop down list store only ids in the database
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