Click here to Skip to main content
15,879,683 members
Home / Discussions / Database
   

Database

 
AnswerRe: how to check the already existing data Pin
Pete O'Hanlon18-Dec-07 0:12
mvePete O'Hanlon18-Dec-07 0:12 
GeneralRe: how to check the already existing data Pin
ShimnaMukundan18-Dec-07 0:58
ShimnaMukundan18-Dec-07 0:58 
QuestionHow can I update databse record on application ending explicitly(power failure) Pin
Gokul Harsh17-Dec-07 22:42
Gokul Harsh17-Dec-07 22:42 
AnswerRe: How can I update databse record on application ending explicitly(power failure) Pin
Rocky#17-Dec-07 23:03
Rocky#17-Dec-07 23:03 
AnswerRe: How can I update databse record on application ending explicitly(power failure) Pin
Pete O'Hanlon17-Dec-07 23:49
mvePete O'Hanlon17-Dec-07 23:49 
GeneralRe: How can I update databse record on application ending explicitly(power failure) Pin
Rocky#18-Dec-07 0:30
Rocky#18-Dec-07 0:30 
GeneralRe: How can I update databse record on application ending explicitly(power failure) Pin
Pete O'Hanlon18-Dec-07 1:16
mvePete O'Hanlon18-Dec-07 1:16 
GeneralSql2005: How to get the error msg thrown from Storedproc to C# class Pin
kssknov17-Dec-07 19:58
kssknov17-Dec-07 19:58 
hi
i had created as SP to delete the record using where condtn.if the record doesnt exists the SP will throw an error as "No such record found" and return 0 .

But my c# code gets -1 rows affected from the sql.its ok.
My problm is how to get the "No such record found" from sql to c#.

ALTER PROCEDURE SP_deleteUserMaster<br />
	@LoginId nvarchar(30)<br />
AS<br />
begin<br />
set nocount on<br />
declare @ncnt int<br />
	select @ncnt=(select count(*)from UserMaster where LoginId=@LoginId)<br />
	if (@ncnt>0)<br />
	<br />
	begin<br />
	DELETE FROM UserMaster WHERE LoginId=@LoginId<br />
	end<br />
	else<br />
	raiserror('No record found',10,1)<br />
end<br />
	RETURN<br />

senthil

GeneralRe: Sql2005: How to get the error msg thrown from Storedproc to C# class Pin
That's Aragon17-Dec-07 21:46
That's Aragon17-Dec-07 21:46 
QuestionRe: Sql2005: How to get the error msg thrown from Storedproc to C# class Pin
kssknov18-Dec-07 21:02
kssknov18-Dec-07 21:02 
GeneralProblem in writing a stored procedure in SQL SERVER 2000 Pin
Member 305788717-Dec-07 19:41
Member 305788717-Dec-07 19:41 
GeneralRe: Problem in writing a stored procedure in SQL SERVER 2000 Pin
pmarfleet17-Dec-07 21:41
pmarfleet17-Dec-07 21:41 
GeneralQuery regarding SQL Pin
sandhya1417-Dec-07 18:45
sandhya1417-Dec-07 18:45 
GeneralRe: Query regarding SQL Pin
That's Aragon17-Dec-07 18:52
That's Aragon17-Dec-07 18:52 
GeneralRe: Query regarding SQL Pin
sandhya1418-Dec-07 1:05
sandhya1418-Dec-07 1:05 
QuestionInsert vs Update Pin
Yusuf17-Dec-07 7:38
Yusuf17-Dec-07 7:38 
GeneralRe: Insert vs Update Pin
Colin Angus Mackay17-Dec-07 8:01
Colin Angus Mackay17-Dec-07 8:01 
GeneralRe: Insert vs Update Pin
GuyThiebaut17-Dec-07 8:51
professionalGuyThiebaut17-Dec-07 8:51 
QuestionFinding triggers that are disabled or not? Pin
Syed Mujtaba Hassan17-Dec-07 0:29
Syed Mujtaba Hassan17-Dec-07 0:29 
AnswerRe: Finding triggers that are disabled or not? Pin
GuyThiebaut17-Dec-07 0:43
professionalGuyThiebaut17-Dec-07 0:43 
Generalhijri calender with sql server 2005 Pin
Ahmad Adnan16-Dec-07 22:38
Ahmad Adnan16-Dec-07 22:38 
GeneralRe: hijri calender with sql server 2005 Pin
GuyThiebaut17-Dec-07 1:30
professionalGuyThiebaut17-Dec-07 1:30 
GeneralMySql database does not store "\" (backward slash) when query using vb.net Pin
Rupesh Kumar Swami16-Dec-07 21:16
Rupesh Kumar Swami16-Dec-07 21:16 
GeneralRe: MySql database does not store "\" (backward slash) when query using vb.net Pin
Giorgi Dalakishvili16-Dec-07 22:00
mentorGiorgi Dalakishvili16-Dec-07 22:00 
QuestionC# : How to get the server machine's current date and time? Pin
kssknov16-Dec-07 20:34
kssknov16-Dec-07 20:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.