tag:blogger.com,1999:blog-7805972021499203804.post8601781654920152343..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: Exception Handling in SQL Server Stored Procedure with TRY CATCHSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-7805972021499203804.post-9818998145041294442017-03-30T03:42:16.669-07:002017-03-30T03:42:16.669-07:00hi sir,
I need your help
BEGIN TRY
use ASB
print ...hi sir,<br />I need your help<br /><br />BEGIN TRY<br />use ASB<br />print 'No errors'<br />end try<br />begin catch<br />print 'Error occured'<br />end catch<br /><br /><br />Error message displayed on below message<br /><br />Msg 911, Level 16, State 1, Line 2<br />Database 'ASB' does not exist. Make sure that the name is entered correctly.<br /><br />This didnt go catchAnonymoushttps://www.blogger.com/profile/06310139775359342312noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-56674256977826937842017-03-30T03:39:29.890-07:002017-03-30T03:39:29.890-07:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/06310139775359342312noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-67315189866637499682016-02-29T04:54:28.934-08:002016-02-29T04:54:28.934-08:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/07162485399176651399noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-70340654776842896752015-10-12T06:53:06.760-07:002015-10-12T06:53:06.760-07:00" how to ONLY INSERT the multiple records int..." how to ONLY INSERT the multiple records into sqlserver database table in one go. "<br /><br />u can do it using userdefined table type.Anonymoushttps://www.blogger.com/profile/15181785385915034444noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-46010007564109060692015-08-13T04:27:07.411-07:002015-08-13T04:27:07.411-07:00good explanation sir.good explanation sir.Abdul Razackhttps://www.blogger.com/profile/00330938183900154448noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-61321482218882122502015-05-05T04:35:40.868-07:002015-05-05T04:35:40.868-07:00hi sir,
I need your help
I want error trapped in ...hi sir,<br />I need your help<br /><br />I want error trapped in catch block of sql server to be shown in gui <br /><br />stored proc<br />try<br />{.....<br />}<br />catch<br />{<br />.....<br />error msg<br />}<br /><br /><br />in<br />c# using ado<br /><br />want to print error msg of catch block of sql server<br /><br />my email id :rathorajay202@gmail.com<br />thanks...Anonymoushttps://www.blogger.com/profile/03570660468852435781noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-46012728854834521362015-03-22T21:29:20.420-07:002015-03-22T21:29:20.420-07:00hi sir,
I need your help
I want error trapped in ...hi sir,<br />I need your help<br /><br />I want error trapped in catch block of sql server to be shown in gui <br /><br />stored proc<br />try<br />{.....<br />}<br />catch<br />{<br />.....<br />error msg<br />}<br /><br /><br />in<br />c# using ado<br /><br />want to print error msg of catch block of sql server<br /><br />my email id :meh.oswal@gmail.com<br />thanks...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-33534264753253644362014-01-10T02:27:43.301-08:002014-01-10T02:27:43.301-08:00Hi Suresh this is fine but i have a problem with d...Hi Suresh this is fine but i have a problem with date .Actuvally am using datatype is datetime in sql but am using string in code behind file for sending date to database . at that time i want to given wrong date format it will show like "error convert type nvarchar to datetime " .My requirement is to show the error like STRING WAS NOT RECOGNISED AS A VALID DATETIME please retrive me SATEESHhttps://www.blogger.com/profile/04886722518112202490noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-83591928379491528972013-12-12T03:27:16.437-08:002013-12-12T03:27:16.437-08:00insert a whole gridview convert the grid view into...insert a whole gridview convert the grid view into datatable and then use the datatable select the datatable and then insert it using linq <br /><br />var toInsert = from b in TableB<br /> where ...<br /> select new A <br /> {<br /> ...<br /> };<br /><br />TableA.InsertAllOnSubmit(toInsert);<br />dc.SubmitChanges();<br /><Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-31854924598726714852013-07-19T01:38:30.355-07:002013-07-19T01:38:30.355-07:00This is Abhinav Singh 993 ; Thank you so much When...This is Abhinav Singh 993 ; Thank you so much Whenever I have been in dilema of thoughts You're guidance is always with me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-12183053030056852942013-06-20T10:57:30.647-07:002013-06-20T10:57:30.647-07:00use bulk upload sql in gridview click eventuse bulk upload sql in gridview click eventgaabahttps://www.blogger.com/profile/03237021301417570271noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-88164543977509137932013-06-19T02:24:46.817-07:002013-06-19T02:24:46.817-07:00Hello sir,
How we can block my website in other c...Hello sir,<br /><br />How we can block my website in other country,like in e-commerce website , international user only can view product bt can't submit order.Anurag Sonihttps://www.blogger.com/profile/02701673308767487825noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-60447869952812832722013-05-08T01:46:04.303-07:002013-05-08T01:46:04.303-07:00by using Foreach loop you can insert the Data in O...by using Foreach loop you can insert the Data in One Click in the Database.Kalyan Reddyhttps://www.blogger.com/profile/01313756254301051217noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-7865390546516887062013-03-11T20:57:38.991-07:002013-03-11T20:57:38.991-07:00vgfggvgfggAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-68205126322353127762013-03-09T06:30:41.972-08:002013-03-09T06:30:41.972-08:00Hello Sir,
Is there any directly PHP to ASP.N...Hello Sir,<br /><br /> Is there any directly PHP to ASP.NET website conversion application??? if yes .. plz send me link for that...<br />thank you...<br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-33761378847323556462013-03-09T04:44:02.990-08:002013-03-09T04:44:02.990-08:00good onegood oneAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-74884579136865763082013-03-09T04:29:01.392-08:002013-03-09T04:29:01.392-08:00Hi suresh sir,
This is J.Prabu, how can i ask m...Hi suresh sir,<br /> This is J.Prabu, how can i ask my question, kindly give me the details to share my doubt.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-62653074114341069392013-03-08T05:18:34.875-08:002013-03-08T05:18:34.875-08:00Hi Suresh,
Ignore my previous post...
this is su...Hi Suresh,<br /><br />Ignore my previous post...<br /><br />this is sunil from delhi..<br /><br />there is 1 question that<br />how to ONLY INSERT the multiple records into sqlserver database table in one go using GridView.<br /><br /><br />thnx in advance<br />waiting for your reply.... :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-28024226161954527402013-03-08T05:17:45.987-08:002013-03-08T05:17:45.987-08:00Hi Suresh,
this is sunil from delhi..
there is 1...Hi Suresh,<br /><br />this is sunil from delhi..<br /><br />there is 1 question that<br />how to ONLY INSERT the multiple records into sqlserver database table in one go.<br /><br /><br />thnx in advance<br />waiting for your reply.... :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-76707493231050960082013-03-08T04:50:12.003-08:002013-03-08T04:50:12.003-08:00how to create calendar which specify special event...how to create calendar which specify special events? plz plz help me.... Anonymousnoreply@blogger.com