C# Discussion Boards - CodeProject

Baeltazor9-Jun-09 6:14

9-Jun-09 6:14

I wonder if there's a way to 'simulate' ALT+PrintScreen and then programatically get data from the clipboard and save it to a file? If there is... That oughta do it... I think

Re: Taking screenshots from games

Anthony Mushrow9-Jun-09 13:54

Anthony Mushrow

9-Jun-09 13:54

There is, there are functions like SendKeys. But there must be nicer ways.

My current favourite word is: Delicious!

-SK Genius

Game Programming articles start -here[^]-

How I can filter out Child Entities

Qasim19849-Jun-09 3:21

Qasim1984

9-Jun-09 3:21

Dear Sir/madom

I have three tables

1. Categorys (ID, Name)
2. Definitions (ID, Name, CategoryID)
3. Versions( ID, Name, DefinitionID)

I have generated three objects using EDM
1 Cagegorys
Navigation (Definition)
2. Definitions
Navigation (Category, Version)
3. Versions
Navigation (Definition)

I want to get latest versions against each category

My Code is as follow It return all version against the categoryId but I want to get only latest version of each definition against a category.

DataEntities data = new DataEntities();

Category cat = (from c in data.Categorys where c.ID == CategoryID select c).First();

IList<definition> defintions = (from d in data.Definitions.Include("Versions") where d.Category.ID == cat.ID select d).ToList();

IList<dynamicforms.data.version> versions;

if (defintions.Count>0)

{

versions = defintions.SelectMany(d=>d.Versions).ToList();

Grid.DataSource = versions;

Grid.DataBind();

}

If I need sub query How I have construct and use subquery in this code

Your early reply will be highly appriciated please.

How to copy the selected tree node along with its children and paste the same

Rafone9-Jun-09 3:20

Rafone

9-Jun-09 3:20

I have been searching the net for 2 months now looking for info on how to do this. Can anyone point me in the right direction?
I have a vb.net program that used SendKeys to send ctrl+C and CTRL+V that was able to do this but I can't get that to go in VS2008 C#.

tia
rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Re: How to copy the selected tree node along with its children and paste the same

Mycroft Holmes9-Jun-09 4:21

Mycroft Holmes

9-Jun-09 4:21

You're kidding right, 2 months wow!

There are a number of options
Context menu gives you right click on the node and deal with the menu option including ctrl C/V
Trap the keydown method on the node for the ctrl C, grab the node and set a flag that a node is copied, trap the next key down for the ctrl V and add the copied (cloned) node to the current selected node.

Never underestimate the power of human stupidity
RAH

Re: How to copy the selected tree node along with its children and paste the same

Rafone9-Jun-09 7:53

Rafone

9-Jun-09 7:53

Yea really...I think if you look you will see some eariler posts going back a couple of months.

I have tried that...all I seem to get is the highlighted node I get none of the child nodes.
Originally this was a VB.net app done with VS2003 they used SendKeys CTRL+C and CTRL+V and it works fine.
Now I am trying to upgrade to C# using VS2008 and the above no longer works (don't get the child nodes)

Any other Ideas??

rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Re: How to copy the selected tree node along with its children and paste the same

Mycroft Holmes9-Jun-09 14:19

Mycroft Holmes

9-Jun-09 14:19

I guess you are copying the selected node and assuming the child nodes are in there - sounds like you need to get the whole structure of child nodes manually during the copy process.

I also presume you are copying the selected node to the clipboard and then pasting from the clipboard and accepting those limitations. This is useful only if you are moving off the app/form/control where you are copying from (and thereby losing the original structure). If it is inside your app why not grab a placeholder on the copy event and when the paste is done go and get the entire structure from the original node.

Never underestimate the power of human stupidity
RAH

Re: How to copy the selected tree node along with its children and paste the same

Rafone9-Jun-09 16:28

Rafone

9-Jun-09 16:28

The way it worked in the old app was they were copying the selected node and pasting using the clipboard. This copies the selected node and all of its child nodes. (they were using the sendKeys CTRL+C and CTRL+V).

The few examples I have found on the net were just the simple copy and paste of the selectedNode.

I have also tried cloning but have not gotten that to work either.

If you have an example or a link to a good example I would be most greatful.

It seems like it should be a simple task but I guess if it was there would be some meaningful examples.

tia
rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

SQL Connection problem

KIDYA9-Jun-09 2:57

KIDYA

9-Jun-09 2:57

Hi there!!

My problem is when i am switching to another SQL SERVER with my project then every time i have to change my connection string.
Is there any way to solve this problem??

Re: SQL Connection problem

Colin Angus Mackay9-Jun-09 3:02

Colin Angus Mackay

9-Jun-09 3:02

KIDYA wrote:
My problem is when i am switching to another SQL SERVER with my project then every time i have to change my connection string.

Why is that a problem? Surely you are storing your connection string in the config file. Or have you hard coded it in to the application itself?

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: SQL Connection problem

KIDYA9-Jun-09 3:04

KIDYA

9-Jun-09 3:04

I have it in config,Now tel me other way.
Please!!! Sigh | :sigh:

Re: SQL Connection problem

Colin Angus Mackay9-Jun-09 3:06

Colin Angus Mackay

9-Jun-09 3:06

KIDYA wrote:
I have it in config,Now tel me other way.

What specific problem do you have with having the connection string in your config file?

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: SQL Connection problem

KIDYA9-Jun-09 3:09

KIDYA

9-Jun-09 3:09

i want common connection string thr' which i can run my project on any server withput changing config connection string.

Re: SQL Connection problem

Eddy Vluggen9-Jun-09 3:11

Eddy Vluggen

9-Jun-09 3:11

..and how will you know how the SQL-server instance on my PC is called?

I are troll Smile | :)

Re: SQL Connection problem

Luc Pattyn9-Jun-09 3:24

Luc Pattyn

9-Jun-09 3:24

you can store such information in a database!

Wink | ;)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: SQL Connection problem

Mycroft Holmes9-Jun-09 4:17

Mycroft Holmes

9-Jun-09 4:17

Telepathic software, the next wave of future development, just think about where you want to be!

Never underestimate the power of human stupidity
RAH

Telepathetic Software is already here

Ennis Ray Lynch, Jr.9-Jun-09 5:38

Ennis Ray Lynch, Jr.

9-Jun-09 5:38

Tele: meaning remote
Pathetic: standing for the quality

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Re: SQL Connection problem

SilimSayo9-Jun-09 6:30

SilimSayo

9-Jun-09 6:30

You can have several connection strings in the same config file. You can design your application in such a way that it prompts the user to select which environment it wants to connect to and then fetch the appropriate connection string from the config file.

Re: SQL Connection problem

saanj9-Jun-09 3:13

saanj

9-Jun-09 3:13

Assume you booked a Air Ticket for California. Now you have changed your mind and decided to go to Paris. What do you think, the same ticket will work? Sorry, just kidding. If you are changing the database, the connectionstring also needs to be changed either in config file or in every places where it is used.

Regards
Saanj

Either you love IT or leave IT...

Re: SQL Connection problem

Simon P Stevens9-Jun-09 5:01

Simon P Stevens

9-Jun-09 5:01

I think what you are looking for is "localhost".

If you set the server name in the connection string to "localhost" it will connect to the SQL server running on the local PC.

You need to explain your question in more detail and explain what you are trying to do, your question is not clear at all.

Simon

Re: SQL Connection problem

deepseeindeepsy9-Jun-09 18:55

deepseeindeepsy

9-Jun-09 18:55

Thanx dude!! u only gave my answer. Big Grin | :-D

Re: SQL Connection problem

Simon P Stevens11-Jun-09 3:08

Simon P Stevens

11-Jun-09 3:08

My pleasure.

The reason that you didn't get any other good answers is because you question was very unclear and difficult to understand.

I'm not talking about the quality of your English (that's fine), but about how well you describe your problem. Next time you post a question, take the time to properly describe the situation you are in, the problem you are having, and what you are trying to achieve.

Simon

Re: SQL Connection problem

Henry Minute9-Jun-09 8:09

Henry Minute

9-Jun-09 8:09

KIDYA wrote:
My problem is when i am switching to another SQL SERVER with my project then every time i have to change my connection string.

That will always be the case.
The only solution, that I can think of, there may be others but they escape me for now.

1. Try connecting using your stored connectionstring, catch exceptions and when the exception shows database absent
2a. Create a clone of the MS Server Connection Dialog and let the user 'find' the right server. OR
2b. Iterate over all available servers and do 1. above uon each one ntil you find the database, then modify the current connectionstring to match.

You might find it useful to read up on the ConnectionStringBuilder class for a fairly easy way to modify connection strings.
You might also want to download the SQLServer 2008/2005 Samples from Microsoft Download site for an example of cloning the dialog. If you do so an example will be found at YourDrive:\YourBaseDirectory\Samples\Engine\Programmability\SMO\ServerConnect\CS\ServerConnect.
In the Samples directory tree you will also find examples of how to find all available servers, so you can iterate over them, if you decide to do it that way.

Of course whichever way you do it, you will be faced with the problem of how and where to store the modified connection string. Smile | :)

Good Luck! Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

checking duplicate value in cell of datagridview

KIDYA9-Jun-09 2:43

KIDYA

9-Jun-09 2:43

Hello Experts!!
During adding records into datagridview i want to prevent duplicate values adding,i am saving multiple values at a time.when i enter duplicate value into specific column then it must show msg for same.
now i am using cell changed event.

Re: checking duplicate value in cell of datagridview

dan!sh 9-Jun-09 3:24

dan!sh

9-Jun-09 3:24

Set the constraint on the column in the DB itself.

जय हिंद

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