Hi everybody. I have webform on wich different kind of control. While i over on links or linkButtons controls my listBox controls flashing (blinking), i don't know why. Note: there are no ------------------------------------ "Imagination is more important than knowledge" (Albert Einshtein)

However how can i know the details of the error such where it occurs in which line. I need something like i get in sql query analyzer. ------------------------------------ To study, study and only to study

How get error description (message) associated with @@Error When i use the FORMATMESSAGE function it's allways returns NULL. Any ideas ??? ------------------------------------ To study, study and only to study

Thanks, however i already solve this problem i use a global table. ------------------------------------ To study, study and only to study

Is it ossible to pass table as parametr to stored procedure??? sql server 2000 ------------------------------------ To study, study and only to study

Anybody know if the COALESCE(NULLIF ...)...) can raise error itself, and if it safely to use this combination of checking error status Every time after i calling to some store procedure i use this: ------------------------------------------ DECLARE @intError int EXEC @intError = myProcedure @param1, @param2 ..... SELECT @intError = COALESCE(NULLIF(@intError, 0), @@ERROR) IF(@intError =0 ) ...... ...... -------------------------------------------- my question is, can the @@ERROR variable have an error that COALESCE or NULLIF function were raise? Thanks. P.S. if it's not good idea to use it after calling to stored procedures so what can u advice me ------------------------------------ To study, study and only to study

ok. Thank u. ------------------------------------ To study, study and only to study

The basic difference between an Abstract class and an interface is that Abstract class allows Concrete method(methods that have implementation) but interface doesn't. The second difference is in terms of inheritance. A class can inherit from only one class but can implement any number of interfaces. One more difference is that interface doesn't allow variables/constants to be declared but abstract class allows for declaration of variables and constants. ------------------------------------ To study, study and only to study

thanks i got it, I have another question to u: i have stored procedure that perform select ... from .... also this procedure return value (e.g. return 0) if i call to the sp by EXECUTE i got the result of my sp(result of query.) if i do: DECLARE @res int EXEC @res = My Stored proc PRINT @res i got only what the sp return. how to get the return value and the query result(set result) both? ------------------------------------ To study, study and only to study

I know that errors with severiry less than 10 is an information error(message) so in the C# i can't catch it in the try/catch/finally block, caues of that i will need to raise my error with severity > 10, after this i will catch this error in my application ------------------------------------ To study, study and only to study

generates the better execution plan, what do u mean by saying it? how to check execution plan in the query analyser. Thank u ------------------------------------ To study, study and only to study

So as i understand: SELECT ..., ...., .... ... FROM .... ..... .... SELECT @myERROR = @@ERROR IF @myERROR != 0 here i handle the error, maybe call to RAISEERROR ------------------------------------ To study, study and only to study

Yes, thanks it's help. However the statement that u wrote: AND (@criteria2 IS NULL OR column2 = @criteria2) possible write as: WHERE column1 = @criteria1 AND (column2 = ISNULL(@criteria2, column2)) ------------------------------------ To study, study and only to study

Ok. If i perform INSERT INTO ..... the most common error is cannot insert duplicate. However if i perform the SELECT and all parameters in my SELECT statement are ok, i.e. no syntax error and also all columns and tables that i specifyed are exist. So is the posibility of some kind of an error that can occur??? ------------------------------------ To study, study and only to study

However if i don'et use dataset, i'm developing only db i don't care what hapen in the application layer. What i should do do delete relevant rows and insert after this or to do some manipulation with data to understand what chenged and aafter this to insert o to delete or to update some rows???? ------------------------------------ To study, study and only to study

What kind of Errors the SELECT statement can raise?? In what cases? How to avoid them? How to handle them? ------------------------------------ To study, study and only to study

I have not big DB (12 tables) Suppose application is requested for some data about specified clientID by means of ADO.NET i got all the relevant data about this clientID from several tables to the client, client perform tasks on this data change it maybe add something new or delete somtething (there is posibility that data will not changed at all), after this client click to SAVE button and return data to DB, here start the problem, i can delete all relevant data about specified clientID in all table and after this insert data tables (insert data that recieved from the application) or i can check what changed and to remove or update or insert data. ANY IDEAS, and maybe how to perform my problem. I'm using: Windows Xp, .NET Framework, Sql-Server 2000. ------------------------------------ To study, study and only to study

What is Reflection, when and were to use it. Thanks ------------------------------------ To study, study and only to study

The simplest way: EventLog.WriteEntry("My App"," there is an error occured on bla bla ..."); Does it help ?? ------------------------------------ To study, study and only to study

Suppose i create sp CREATE PROC myProc @criteria1 int, @criteria2 nvarchar(50) = '' AS SELECT * FROM myTable WHERE column1 = @criteria1 AND column2 = @criteria2 GO --------------------------- my question is in case the parameter @criteria2 is empty (equal '') i want the select will ignore this criteria so it perform like: SELECT * FROM myTable WHERE column1 = @criteria1 ----- the same with other criterias. I can have a lot of parameters and and some of them can be empty or not. Thanks. ------------------------------------ To study, study and only to study