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 ;)

very nice thanks

reza assar wrote: any other suggestion? It might speed up things if you search (Ctrl-F) the entire solution for "SqlConnection" and add a using-block to each instance found. That would, in theory, dispose of your connection once processing exits the defined scope, and thus, also close it. I are Troll :suss:

You mean concatenate them? If so then... set @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.

reza assar wrote: i know bun unfortunately i can`t derive from desired class because it force me to change all of the project Sounds like the requirements and specs changed after development started. You really have to plan ahread for these things. reza assar wrote: in addition i am looking for a better solution You don't have one. Extension methods cannot be attached to a property of a type, only to the type itself. A guide to posting questions on CodeProject[^] Dave Kreskowiak

All hashing algorithms give ambiguous results. The number of expected collisions is directly proportional to the input size, output size and quality of the hashing algorithm. Read the Wiki page on the subject for more information about hashing. Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost

thanks it does work fine!

Run profiler and see where the costs are! Never underestimate the power of human stupidity RAH

well, [defaultValue] is not for setting initialize value for an object, it just change appearance of the property in design time, [DefaultValue("hello")] public string txt{get;set} now in design time when you change the text of this property it would be bold text! for ur purpose u should define ur property as this: private string _txt="Hello"; /// ur initialize value!!! public string txt { get { return _txt; } set { _txt=value; } }

Does CR support List<> as a datasource? I have not used that POS in a few years but I doubt it has moved that fast. I suggest you do some research on the Business Object web site. Never underestimate the power of human stupidity RAH

reza assar wrote: error is: "Missing semicolon (;) at end of sql statement" what should i do? Quote Selected Text try reading the error message, then engaging brain. Seriously, if you cant debug the error given the erro message then give up programming now.

hello thanks good answer but give me some more please!

Looks to me like you are missing the field list. Eg. insert into myTable (field1, field2, field3, field4, field5) values(123,'123',123,123,(select DISTINCT ID from ServiceGroupsInfo where NodeName='abc')) though I would further modify it to: insert into myTable (field1, field2, field3, field4, field5) Select Distinct 123,'123',123,123, ID from ServiceGroupsInfo where NodeName='abc'; I'm not convinced by the distinct either, as surely ServiceGroupsInfo is unique by NodeName, or it will give multiple results for ID anyway. If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles]  [My Website]

All the fields in each row in your table, are automatically related to each other, by being in the same row. You can not and do not need to create any relationship. If you want to relate values from one row to those in another row, you will have to create two tables, and create a relationship between those. So for example something like: Table 1: Nodes (ID, NodeName) Where ID is unique Tabl e2: UpareNodes (ID, NodeName, Parent_ID) Relation: Nodes.ID = UpareNodes.Parent_ID My advice is free, and you may get what you paid for.

You may use XML for this with succes! :) Give it a try. Good luck! Alex Manolescu

thank you for your attention i really love this site with its responsible people

thank you for your attention but i am using vs 2005 .net 2.0 thanks anyway i really love this site with its responsible people