Тёмный

Insert Delete Update Select Using Web Service and Stored Procedure Using ASP.NET 

techsapphire
Подписаться 15 тыс.
Просмотров 79 тыс.
50% 1

In this lecture, you will learn to do basic CRUD (Insert, Delete, Update and Select) operation using web service and stored procedure. To complete this lecture you need database script, web service and website to test. To download code and script follow link below:
www.techsapphire.in/index/inse...

Опубликовано:

 

7 мар 2015

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 37   
@thanhthai9127
@thanhthai9127 5 лет назад
Thank you. what's a useful video. I have learned so many things from it. once again thank you very much
@ezuwanzakaria4294
@ezuwanzakaria4294 7 лет назад
Thanks sir for the superb interesting and good tutorial to create web service .your video help me a lot to create my 1st web service .hope you can continue uploading good tutorial and fix the audio .thanks sir from malaysia :)
@calaco74123gaming
@calaco74123gaming 3 года назад
Thanks you saved me time, I just need to pass it to json
@techsapphire
@techsapphire 3 года назад
Glad it helped, use newtonsoft for json processing it is very simple.
@obany1764
@obany1764 2 года назад
Thank you so much for this video! :)
@techsapphire
@techsapphire 2 года назад
Glad it was helpful!
@ntin05
@ntin05 7 лет назад
I LOVE YOU!
@unnamedindividual7135
@unnamedindividual7135 9 лет назад
Thank you for sharing this video. it helped me a lot.
@techsapphire
@techsapphire 9 лет назад
I have few more articles, URL for my sql article are: www.techsapphire.in/index/complex_queries_sql_server_query_optimization_and_interview_questions/0-146 www.techsapphire.in/index/subquery_or_sub_queries_in_sql/0-155 www.techsapphire.in/news/sql_xml_queries/2014-06-10-49
@johanmendoza9825
@johanmendoza9825 5 лет назад
Wow, Thanks so much! you made it look so easy
@techsapphire
@techsapphire 5 лет назад
Thank you for your comment.
@cheapache2524
@cheapache2524 7 лет назад
How to update from datagridview to db use webservice ? I don't understand while create procedure. Thanks a lot.
@sudarshanwaghmode6954
@sudarshanwaghmode6954 3 года назад
Very useful this article I learned lot . I appreciate your views.
@techsapphire
@techsapphire 3 года назад
Glad it was helpful!
@kristinananeva2938
@kristinananeva2938 8 лет назад
THANK YOU! THANK YOU! THANK YOU! That helped me a lot!!!!
@techsapphire
@techsapphire 8 лет назад
+Kristina Naneva You are welcome :) And also do check complex queries video too. It will help you in reducing your code. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Fypof-gD_BE.html
@kristinananeva2938
@kristinananeva2938 8 лет назад
+techsapphire Thank you once again!
@techsapphire
@techsapphire 8 лет назад
You are welcome again
@abhijeetghatage5045
@abhijeetghatage5045 6 лет назад
hello, i want to know how to pass datagrid values to webservices ??
@mithunMADDY9
@mithunMADDY9 9 лет назад
very good !!!
@wasiqkhantech
@wasiqkhantech 5 лет назад
helpful great
@GAUTAMKUMAR-ni1xs
@GAUTAMKUMAR-ni1xs 5 лет назад
Thanks a lot for creating such a explanatory video. It helps me a lot to develop my application i.e Web service to connect to SQL database and fetch data from some tables. This application is hosted locally to IIS under Default web site, but I need it to auto-update/auto-refresh itself at every 2 seconds so that the application which is consuming this web service will always get updated data. Is possible to auto-update the web service?
@techsapphire
@techsapphire 5 лет назад
Web service can pull latest data whenever it is getting request from your application. Webservice don't hold data of its own.
@fito1138
@fito1138 7 лет назад
thank!!!!!!!!!!!!!!
@charanch3318
@charanch3318 5 лет назад
what if there a more number of parameters , so can we create a entity and pass that enttiy object as parameters to webmethod. how to do it?
@techsapphire
@techsapphire 5 лет назад
yes you can pass objects
@sudarshanwaghmode6954
@sudarshanwaghmode6954 3 года назад
Nice article
@techsapphire
@techsapphire 3 года назад
Thanks
@2000jaime
@2000jaime 6 лет назад
excelente video, where i can download the project
@techsapphire
@techsapphire 6 лет назад
you can download code from this link www.techsapphire.in/index/insert_delete_update_select_using_web_service_and_stored_procedure_in_asp_net/0-156
@shovikanand3214
@shovikanand3214 5 лет назад
Good one but ... audio n video quality.must improve.
@suvarnaavhad4689
@suvarnaavhad4689 7 лет назад
kindly show script inside the stored procedures
@techsapphire
@techsapphire 7 лет назад
You can download from link www.techsapphire.in/index/insert_delete_update_select_using_web_service_and_stored_procedure_in_asp_net/0-156
@ntlzz93
@ntlzz93 9 лет назад
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object. at WebServicesCRUD.Client.InsertDetail(String PersonName, String PersonCity) in E:\Tin\C#\Source\WebServicesCRUD\WebServicesCRUD\Client.asmx.cs:line 27 --- End of inner exception stack trace --- Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object. at WebServicesCRUD.Client.InsertDetail(String PersonName, String PersonCity) in E:\Tin\C#\Source\WebServicesCRUD\WebServicesCRUD\Client.asmx.cs:line 27 --- End of inner exception stack trace --- I can't insert . This is my error. Help me
@RahulPatil-zw1cb
@RahulPatil-zw1cb 9 лет назад
Ntl zz i also got same error.. plz check your connection string.. After checking my connection string the issue was resolved...