Calling a stored procedure with output parameters Part 7

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

[@Trzbne]

"Harvest the value" - what a wonderful expression! Dear Venkat, when I watch many of your tutorials, my pronounciation improves, I get more compliments on that lately.

[@MS-fz8jn]

Thank you very much Venkat ....it is because of you that I have developed an interest in microsoft technologies....thank you very much !!! :)

[@RishabGoonoa]

If I could give this video 1000 upvotes, I would. Thank you very much!

[@aliazad1118]

This video was such a useful. I cannot say how thankful I am now for watching this video. Thank you very much for your time.

[@benakin9172]

again, you've pretty much saved me hours upon hours. thank you

[@atos70]

Thank you for all this. Your explanation is so good and clear that I a beginner now have confidence that I can know how to develop an aspnet application.

[@iskenderbayndr4442]

This is the most helpful video tutorial I've ever watched. Thank you

[@TheNopseudo]

Seem so simply when you explain it ! you 're definitivly a good teacher! thanks a lot one more time! ... own memory overload, one other side

[@nitindeb9578]

I saw this video yesterday and forgot to mention how awesomely you explained this program. :)

[@mouradbarakat123]

Excellent video! Very organized, very well prepared, great presentation. Simply the best videos on the subject.

[@tereeda]

Awesome job! You are very generous. Can't thank you enough.

[@spyrex3988]

this dude is a life saver

[@atlrafa]

You really understand your stuff inside out, the explanation makes it seem so easy. Thanks again.

[@coolwaterdvr]

I know this is an old video. Lesson is still applicable today. Used this on my Blazor using stored procedures. Thanks Venkat.

[@chandanreddy2433]

ur amazing sir,no words for ur wonder ful videos................thankuuuuuuuuuuuuuu sir

[@coolwaterdvr]

You are awesome. Thanks for your tutorials. Please don't stop making videos.

[@sameerapatrawala2827]

Very useful tutorials. Thanks Venkat for sharing this easy to understand materials.

[@jolmespastora5260]

Thanks man, this helped me out of a bind today!

[@leosaravia01]

Thank you very much for the help! Your explanation is really clear. This videos help a lot! Thanks again man!

[@radiantcjuan]

thank you venkat! you are a life saver!

[@florescucornel3380]

Thank you for taking time in creating this series of videos. They are very helpful in understanding this part of .NET framework and very well explained.

[@anwarhamoude2637]

Thanks for the tutorials. I had no problem with SQL Server Management Studio to work- this is the first time I've used it.

[@naodagere8210]

You are extraordinary!

[@Wasifali302]

Excellent Work Sir. Thank you for wonderful contribution

[@juanfcodelacruz]

Excellent tutorial Thanks a million!

[@tdholland2003]

Well Done!! Just what I was looking for, Thank You!

[@AlwaysCurioussssss]

Very Helpful video..thanks a lot!!

[@Csharp-video-tutorialsBlogspot]

This is a very good question. Let me record and upload video on this. Will do it in the next few days. Thanks for asking.

[@antoniolopez4165]

Great way to explain a complex subject.

[@ricardowilliamssaldanaleon3886]

Excelent master, is very helpful.

[@Miqraali]

Thanks alot venkat ! the way in which you explain the things and concepts is beyond awesome and seriously no words for your contribution :)Plus i want to know the sequence in which i should follow your video series..

[@leosaravia01]

+Miqraali Totally agree!

[@89Ssik]

+leonardo Saravia 1. C# 2. Dot Net Basics 3. SQL Server 4. ADO .NET 5. ASP .NET 6. GridView tutorial 7. MVC 8. WCF 9. Entity Framework 10. LINQ 11. LINQ to XML 12. LINQ to SQL 13. Chart Control 14. JavaScript 15. JavaScript with ASP .NET 16. jQuery 17. AngularJS?

[@rsardinhag]

It was perfect. Vey good. The video is supper.

[@ashishtyagi3]

Very good and explanatory ....Thanks Venkat

[@Csharp-video-tutorialsBlogspot]

Hi Immanuel, there are more videos on insert, update, delete and select in gridview video tutorial. Hope you will find them useful. Good luck.

[@vinapu559]

These videos are really helpful and i want you to share more and more videos on different technologies...:)

[@gurucharanbiswal2125]

excellent tutorials ...thanks venkat

[@LetCode96666]

VENAKT i love your videos! they are always on point! Gonna start watching your .NET CORE videos soon

[@marklesterechavez7228]

Hi kudvenkat! I'm here again. First of all, many thanks for these tutorials and I learned allot from you. I don't know if i'm in the right section, First question: how can I put optional parameter as many as i can in my stored procedure? so my stored procedure would be more flexible. can u you please add another video on this in your sql tutorial? I would greatly appreciate that if that happens. Many thanks again

[@ripongogi5297]

very useful as well as informative

[@Zolamanuel10]

Hi Kudvenkat, Thanks a lot for your wonderful work!!! can you include more videos base on update,delete,edit and selecting data?

[@gayathripothineni8351]

What is the difference between add and add with value?

[@MrAnupamBorah]

Nice video , very informative !!!!!!!

[@ravikirang4439]

Really helpful man..

[@AMPMasti]

thanks for your video tutorial its very helpful...

[@bonniesterling2478]

worked perfectly!

[@brijeshkumarrai6376]

outstanding .....you are sir

[@ShahabKhan-qh9mg]

Thanks for explaining complex looking topics in easy way . Any video in future regarding pagination with ado net & stored procedure . Also is there any video on functions & cursors like stored procedure in ado net regards shahab (zohaib)

[@johnnydepp1499]

hey kudvenkat thanks for the video series. They way of your teaching is so simple and easy to understand, i find your explanation more easier than other. that's why, whenever i get confused, or want to learn, i always search your videos. Thanks and you have been very helpful. could you make videos on @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT and what's the difference between cmd.parameters.add vs cmd.parameter.addwithvalue. it'd be very helpful thanks

[@SiyamandRashid]

thanks alot for your all great videos ... could you explain what is output parameter, advantage and when we need to use them... what i understand for you video it used for Primary keys when they are auto increment s , im right ? regards

[@Kraken_Z]

thank you ................................enlighten me

[@nishatroyhana6119]

u r the best

[@zoeliu2651]

very helpful.Thanks.

[@Csharp-video-tutorialsBlogspot]

Hi Mark, I don't think I have understood your question. Can you please rephrase it for me again?

[@bebek8989]

thank you sir for explaining

[@unlimitedRewind1]

BooKMark: study Again. Thanks very good tutorial.

[@RCpilotgr]

Hello, I have one question please, How i can modify the stored procedure to DELETE, UPDATE and SEARCH a table? Thank you for all your Videos!!!! George

[@Tall-Cool-Drink]

Thank you for the excellent tutorial. Is there a shorthand way to write the Output Parameter portion of your code? Thanks again.

[@binalgohil8791]

Very Helpful..

[@Zolamanuel10]

Hi.....thanks a lot for your reply, they are quiet helpful...! and is there any video based on finger print reading/recognizing? basically a form with finger print spot option that register users and recognizes user based on their finger print mark. i will be very glad if you can help me out on this!! thanks a million!!

[@Ayubajbnabi]

very nice demonstration

[@markhynes2588]

Great tutorial Does anyone know what the difference is between input and output parameters in sql????

[@dheerajkeerthi]

thank you very much

[@louououou]

Thank you master

[@mathewspjacob1166]

Thank You!

[@hemantkuttepatil9872]

very helpful..

[@Csharp-video-tutorialsBlogspot]

+hemant kutte patil 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. Kind Regards Venkat

[@tjs4278]

Sir I am doing wpf shopping cart application using ado.net connected architecture.I have to perform crud operations on several tables which have foreign key constraints resulting into conflict exceptions.what is the solution for that?

[@animeshbabu2008]

dear venkat when i try to run this code i got an error 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. how to resolve this

[@seyhakhiev1496]

Hi sir, what should i do if i want get all records in each columns of table in store procedure using parameter output?

[@sagarparit10]

Thanks you..

[@jurgenarleyelizondo2045]

I have a question?, How can i call a table from a store procedure from the visual studio in c##? I've seen the video and you get just one value yet i want to get all tha table.... Thank you

[@vin2629]

+Jurgen arley elizondo hai try this string connString = ""; string sql = "name of your sp"; using(SqlConnection conn = new SqlConnection(connString)) { try { using(SqlDataAdapter da = new SqlDataAdapter()) { da.SelectCommand = new SqlCommand(sql, conn); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); da.Fill(ds, "result_name"); DataTable dt = ds.Tables["result_name"]; foreach (DataRow row in dt.Rows) { //manipulate your data } } } catch(SQLException ex) { Console.WriteLine("SQL Error: " + ex.Message); } catch(Exception e) { Console.WriteLine("Error: " + e.Message); } }

[@sandeepingh3401]

sir there is some problem while i m inserting the values in the integer form..the error is dat it can not convert to int...and it is d best way to submmit information of user in a form through store proc..plzz hllpp me sir plzzzz

[@supriyak9542]

Can u plzz tell me how to return multiple output values from sp to function .

[@mimichfury6329]

Hey i want to understand something.. Say for e.g. The question-"within a procedure, the value of radius is input, area is calculated and output. This procedure is called from calling program." So the answer is:(pseudocode): Procedure Area Declare a: real ; rad: integer Input rad a

[@rolensikhrakar5199]

Can you please upload video series of LINQ?

[@honeesh1]

Thank you

[@stannisbarracuda5693]

wow wow just wow

[@rajnadkar7915]

I checked to this code thoroughly and implemented it in my project. But the out parameter part isn't working.. It's throwing exception

[@BilalKhan-eq6gx]

what exception is it throwing???

[@rajnadkar7915]

@@BilalKhan-eq6gx thanks for asking programmer :) ... But the doubt is solved now... The exception was because of my inadequate knowledge

[@89Ssik]

With Auto increment option on ID colum, everything works as expected, but if we for example add row with ID 7, 8, 9... And then delete rows where Id is 7, 8, 9 new autoincrement ID that we add will be with ID 10, which doesn't make any sense, as we deleted ID 7,8,9 .. So it should start from 7 again. I don't understand why is it like this. So basically -> automated ID 7, Deleting ID 7, Next ID is automated 8 instead of starting from 7 again, because our table has only 6 IDs.

[@ionelaurelian1]

when you delete a row with delete command you delete the data from table not the autoincrement, if you want to delete the auto increment use truncate table.

[@jamet60]

can you please show the code ? i need the asnwers too.

[@ionelaurelian1]

truncate table [tablename], this will delete all the data in the table, so be careful when use truncate table.

[@sowsanura]

getting an error while once i clicked my submit button .. colud anyone pls help on this Procedure or Function 'spGetDetails' expects parameter '@Eid', which was not supplied. where @Eid is the employee id parameter

[@kiranpedamkar]

hi sir there is one request pls except that, i want to know how to execute stored procedure in ado.net using DAL and BAL thorugh LINQ...

[@marklesterechavez7228]

sorry to bother you. my question was, how will I add an optional parameter on my stored procedure? just like optional parameter in c#

[@chandrasekarradhakrishnan8932]

Sir am getting a error its saying "Must declare the scalar variable "@Empid" what might be the reason sir.

[@saleem1029]

Chandrasekar Radhakrishnan Declare @EmpId int Execute AddEmployee 'John','Male','9000',@EmpId Out Print 'Employee Id = '+ cast(@EmpId as nvarchar(2)) So here Every time you execute you should also select the line Declare @Empid also and click Execute together with the lines of code in which @Empid is present like in here, select all the above three lines each time you execute

[@sagarvarma3919]

Sir what the @ signifies before writting variable

[@80amnesia]

AAA

[@RampritSahani]

Sir this really

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