Part 13 FormCollection in mvc

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@robertosterberg]

Thank you Venkat for making MVC understandable and Fun to learn. I think that building on what you previously showed in your videos is a great way to learn. Keep it up!!

[@samirayusifova4518]

Perfect as always!! Venkat, you are the best of the best!!

[@PedroGirona]

Thank you very much from my heart for your tutorials. They are PERFECT!

[@bheesham1985]

how can i connect throgh entitity framework

[@vityamv]

yeah, the tutorial starts with EF and then this ADO coming from nowhere :(

[@theZINGcollection]

I don't get it.. Why are you still using ADO.NET when you're working with EF?

[@ashvinbhuttoo]

+Visovan Iuliu Yep exactly my thoughts.. Also i am getting the index command separated in the gender field, weird.. like "Male,3", had to strip it off with split(). public ActionResult Create(FormCollection formCollection) { Employee employee = new Employee(); // Retrieve form data using form collection employee.name = formCollection["name"]; employee.gender = formCollection["gender"].Split(',').First(); employee.title = formCollection["title"]; employee.departmentid = Convert.ToInt32(formCollection["departmentid"]); using (var ctx = new EmployeeContext()) { ctx.Employee.Add(employee); ctx.SaveChanges(); } return RedirectToAction("/Index"); }

[@ahmadahsan5146]

+Visovan Iuliu You are right why ADO.NET when Entity Framework is there. Is it not possible to use enitiy framework with business logic objects?

[@theZINGcollection]

+ahmad ahsan Entity framework can do anything.

[@ahmadahsan5146]

Thanks for your answer. Yep you are right, actually part 16 of this series also clear my confusion.

[@arianitonline8748]

I think cuz this Asp.Net MVC series are a bit old

[@mohsinnaveed9082]

Great Work Man, very informative Thanks.

[@CheeseBae]

Wow, Venkat, I had no idea you were so young.

[@dsingh3205]

Thank you sir once again for uploading two more videos on MVC. HAVE A GREAT DAY.

[@nataliaps]

is there anything like ModelState.IsValid for the formcollection?

[@jautrsezis]

Can someone tell me why at top of the posted values i see also the "Key_pbkY4ddM...?"

[@N3PatHYA]

jautrsezis i had the same issue. Have u solved it?

[@BrettStrife]

jautrsezis N3PatHYA You need to set the primary key to auto-increment, or else if you have a non-nullable column, with no default value, if you provide no value it will error.To set up auto-increment in SQL Server Management Studio:Open your table in DesignSelect your column and go to Column PropertiesUnder Indentity Specification, set (Is Identity)=Yes and Indentity Increment=1 But I had to make a new table to set this property..

[@ivandiazToti]

great work pal... thanks for the tutorial

[@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

[@AbhishekTiwari-sg7bd]

Can i send Form Collection value from the Focusout Event to Controller ?

[@orcunozdil8227]

Hello Mr.Venkat, thanks for your videos. could you give please an example with a datetimepicker as a htmlhelper?

[@vityamv]

why is the con string ["DBCS"] ??

[@gustavodanielpalmaestrada6614]

"DBCS" is the connection name in web.config

[@gurunathrao2985]

Great tutorials Venkat !!! Keep up the good work

[@jaswantrajput437]

Excellent Work Venkant !!!!!!!!!! Excellent efforts

[@gustavodanielpalmaestrada6614]

Hi, I'm using VS2017 and when I execute the foreach formcollection I get this key above Key = Name Venkat: Key = __RequestVerificationToken Lj8X4XJWGmvHQxflmEK0te..... What is this for?

[@karananeja8054]

I've followed the same steps mentioned in the video! but i'm not able to save any data to Db! Any idea what might be wrong?

[@gustavodanielpalmaestrada6614]

maybe your connection string

[@SanjayKumar-ij9pe]

I am not able to see bcoz of subtitles. Please make it transparent or remove. Your voice is clear, every one can understand

[@Csharp-video-tutorialsBlogspot]

Hello Sanjay - Thank you for the feedback. Those are automatic subtitles and you can turn them off using the CC button that you find on the bottom right hand corner of the KZbin player. Hope this helps.

[@SanjayKumar-ij9pe]

@@Csharp-video-tutorialsBlogspot thanks

[@sayalichopade1270]

what all controls values can we get from FormCollection, like Textbox, textarea ?

[@divewithshubham]

Sir I get output together with that i get request verification code and set characters printed along with it.. i dont know y?

[@rishavraj3127]

Sir all r running but showing exception in datetime textbox,that date is out of range

[@narendarsingh4672]

Great Sir,I am grateful to you.

[@wweprince5074]

Sir your get code not seen means what you write within a get

[@humairasyed]

Hello sir, I am getting error when I change the 'Gender' field to DropDownList. If I keep it as textbox(as the default) I am able to insert data. I followed everything in your videos. Here is the error I m getting: Error: Procedure or function 'spAddEmpData' expects parameter '@Gender', which was not supplied. Why is it getting? Help is appreciated. Thanks.

[@Amodarling]

is it possible to get table value through form collection in controller ?

[@shivaprasad1968]

hi everyone im getting following error can anyone help me please Procedure or function 'spAddAllEmployees' expects parameter '@Name', which was not supplied.

[@allanantony1039]

Check Your code in the addemployees method while adding parameters of stored procedure.You must be giving the same name parameter to rest of the parameters. E.g: Your first parameter code: SqlParameter paramname=new Sqlparameter() paramname.ParameterName="@name" paramname.value=employee.name; cmd.parameters.Add(paramname) Your second parameter code: SqlParameter paramgender=new Sqlparameter() paramname.ParameterName="@name" paramname.value=employee.name; cmd.parameters.Add(paramgender) change the second and third lines paramname to paramgender.I hope this works.

[@shabdalisangale4894]

Plzz anyone can tell me where he written that ado.net code .Is it in separate class or somewhere else

[@shivanshrawat3617]

where can we get Source code for the project?

[@sushantbaweja424]

It is displaying key:__RequestVerificationToken with its value aswell i don't want this to get displayed what to do ?

[@larabsteve3350]

can anyone help me here?? I didn't get the posted data on my procedure???

[@muratalalmis]

this video is not streaming. Should you make control it?

[@deeppachehra9962]

Sir if you see this message Please do reply Actually am encountering an error "That I have already have an Action Result with name Create " and i have decorated both with [HttpGet] and [HttpPost] still getting the error. Please Reply.

[@kavishpahade1337]

DEEP PACHEHRA You should have different parameters for both the methods..

[@PrashanthOlekar]

all working fine sir, when i clicked on create button, page redirect to Index page and it will not show newly created row, i have got this error in console. "[Deprecation] Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience."

[@roshanchaturpale5431]

Error converting data type nvarchar to datetime when we adding(creating) the data how to fix this error??? sir

[@romangavrilov3745]

Hi, Great Tutorials! But why are you don´t using Entity Framework any more ?

[@gurunathrao2985]

For the DataAccess, I was getting an error like (the parameter @Name required for the stored procedure was not provided .) So instead of using 4 lines to attach a parameter to the SqlCommand, we can use: cmd.Parameters.Add(new SqlParameter("@Name", emp.Name)); Just in case someone encountered a similar kind of error.

[@nvnvashisth]

are you trying to make json?

[@shanmugam85]

Really Nice and Easy for learning. Thank you very much. But I have one doubt. Is there any special reason for using StoredProcedure for simple read or insert record into the table?

[@joseantoniosanchez4364]

Firstly, congratulation for this complete tutorial. I have a problem in this part. I have an error when execute the app. The error is of type System.NullReferenceException in AddEmployee method. The error appear in the line of string connectionString = ConfigurationManager.ConnectionString["DBCS"].ConnectionString, and i can't fix this problem. Can you help me?. Also the error is: Object reference not set to an isntance of an object. I complete all steps in this part, and try to fix the problem but at this time it's imposible for me. Thank you in advance.

[@bmonye854]

it's because you doesn't defined the "DBCS" connection on web.config, back to part 8 on this tutorial to see more details

[@joseantoniosanchez4364]

+belizmon i cheked the file web.config and it is correct. I have solved the problem. Thank you for your collaboration.

[@moeenhasan9600]

great videos on MVC

[@divewithshubham]

While recieving data from form to controller an error is showing "Input string was not in a correct format." when it has to convert from string to integer. Help someone!!

[@raysunqi]

Thank you, very useful

[@tejamachineni]

u r awesome....

[@kushagrakhandelwal8867]

can anyone please paste ADONet interview blog From venkat

[@armanx2]

hi Friend, i think your videos are awesome to watch and learn stuff you are making great tutorials well explained etc. however what i think is kinda confusing is when you call name buissnesLayerEmployee which seems to me is more like DataAccesLayer and class itself to me looks like more a repository of the Employee class in my personal experience. maybe you have a reason to call it so but so far i do not see the point ? would you like to explain it if possible. thx very much in advance ! ps. thx for all the hard work for creating and posting these tutorials really AMAZING job !

[@kapamagicman]

Can you make more SQL videos on advanced topics?

[@dreamcanvas71]

Thanks, all in one solution

[@joseperez-lf7if]

very usefull!!!

[@MrVibhore1989]

Thanks Sir :)

[@shrinaveen4508]

nice tutorials

[@mauroldanr]

Thank you

[@mohamadalibrahim2995]

thanks

[@guleye]

Skip BusinessLayer, coudnt understand about that.

[@wweprince5074]

In employeeBusinessLayer

[@ihorfedorchuk]

лучшие уоки