hi thanx to ur answer it took a time fore me to understand what just going on i will try it and answer back :) :-D ;)

hi all suppose i have a table named "PlaceHolder" with this fields

ID int
TableName nvarchar
FieldName nvarchar

these fields will indicate specified table.field in my databse so i want to retrieve them and use it`s content as a tableName.fieldName in my select transaction

SELECT [SQL1].[NewFieldName]------> REPLACED WITH '[TableName].[FieldName]' RETREIEVED BY INNER SELECT FROM
(SELECT '['+[TableName]+']' + TableName + '.['+[FieldName]+']' NewFieldName
FROM [PlaceHolder]
WHERE ....
) AS SQL1
WHERE ...

it will show me the names of some [tables].[field] but i want it`s values in these fields

very nice thanks

dear friend 1- thanks to your reply it works for part of my storedprocedure 2- i heard that CASE is not high performance statement 3- what should i do if i want to shorten this block of code?

if(@flag=1) then
select * from TBL1
ELSE
select * from TBL2

i think this is not applicable to using CASE am i right?

hi all i want to use some thing like that

set @a=@AnimalName == "Elephant"? "savannah": "unknown"

but it has an error in == how can i fix it? besides i want to use conditional ?: operation to concat some strings like bellow how i should so;ve this problem?

N'insert into TBL Values(@Val1,'+ @Condition = 1? N'val2':N'val3')+',...'

thanks Eddy yes maybe . i will check it and fix it (if there is any) and get the result back hear. any other suggestion?

dear Eddy i am using exception handling the error is the same as when you can`t establish a connection. good suggestion about eventlog i completely forgot about this. by the way my application can`t establish a connection but meanwhile another applications "that developed by myself" can connect and dial with sql server remotely from other computers at the same time.

Eddy Vluggen wrote:

Did you mean that your database-server doesn't accept any new incoming connections after that week, or that it drops the current existing connection?

yes i think there is no any connection object in the pool " and database-server doesn't accept any new incoming connections" and it does not allow establish a new fresh connection but after restarting the client computer everything working ok!

hi all does any one know or guess what happens to my application connection while dialing with sql server 2008 standard? in fact it works for a week and after that it stops establishing connection to server remotely 1) i can ping the server from the computer witch my application installed on 2) sql server service is running 3) only one instance is installed on the server computer (sql server 2008) 4) my application will works about a week and dialing with sql server remotely more than 10000 times per a week and suddenly it stops 5) it will be ok after restart computer witch my application installed on :doh: :wtf: :confused: :~ X| :suss: .....!!!!!??????

modified on Monday, February 28, 2011 7:55 AM

Cursor.Position will retrieve current position of the cursor on the screen good luck

DataGridViewTextBoxEditingControl.autocomplete conflict with wrap mode i can`t use advantages of autocomplete when wrap mode of cellstyle set to true what should i do to have both at the same time? any suggestion ? any link? any article? any keyword to search about?

modified on Tuesday, February 15, 2011 7:06 AM

hi all i am using sqlServer 2008 so how to attach two varbinary(MAX) variables? @bin3= @bin1 + @bin2 ?????? :)

hi dear gonzalo NO i used DefaultValue intentionally to prevent designer from generating this line of code there is no different from having DefaultValue or not (i tried this senario several times) and it does not work. i seams designer will clone the object and copy all the changed properties and i have to copy may new property implicitly.

hi the answer is Pretty simple public class DataGridViewTextBoxColumn2 : DataGridViewTextBoxColumn { [DefaultValue(typeof(bool), "false")] public bool IsMandatoryColumn { get; set; } public override object Clone() { DataGridViewTextBoxColumn2 test = (DataGridViewTextBoxColumn2)base.Clone(); test.IsMandatoryColumn = this.IsMandatoryColumn; return test; } } i love internet :laugh:

hi all i derived a class from DataGridViewTextBoxColumn named DataGridViewTextBoxColumn2 public class DataGridViewTextBoxColumn2 : DataGridViewTextBoxColumn { [DefaultValue(typeof(bool), "true")] public bool IsMandatoryColumn { get; set; } } in design time i click the Edit and change the value IsMandatoryColumn to true but when i return to edit form to chock if the property set to true or not surprisingly i find this property with the value of False please help me by the way i tried to implement a constructor and set the default value there and also tried to change the access method to old form of get{return ...} set{...=value} but the problem still persists pleeeeeeeeeeaaaaaaaaaaaaaaaaaase help me before i gonna crazy:mad::~:confused:

i know bun unfortunately i can`t derive from desired class because it force me to change all of the project . in addition i am looking for a better solution

hi all i want to Extend a Property for a class is there some thing like Extension Methods for properties?

it would give ambiguous meaning does anyone know something about this problem?

hi no i need a class implemented in .net some thing like MD5 Class . but it have to generate byte array of length 6 to 10 (not 16 byte or higher).

hi all is there any 64bit hashing algorithm implemented in .net? i am using .net 3.5 and need to encrypt a string with length of 3 to a byte array of length 8 or 10 for example : hash("ABC")="!@?{%ER)@w" any suggestion?

thanks it does work fine!