C# Discussion Boards - CodeProject

Highlight

simworld16-Jan-08 8:47

simworld

16-Jan-08 8:47

How to automatically Highlight (Select) value of a Textbox ,when typing the value in Textbox.

Re: Highlight

DaveyM6916-Jan-08 8:51

DaveyM69

16-Jan-08 8:51

Look at the Select and SelectAll methods as well as the SelectedText, SelectionLength and SelectionStart properties of the TextBox.

IPC - best solution?

DaveyM6916-Jan-08 8:10

DaveyM69

16-Jan-08 8:10

I need two way communication between a Windows Service and my Windows Forms Application that will be running on many computers across a LAN.

The service will need to accept small but frequent ammounts of data from all the winforms apps simultaneously and to be able to send response messages back.

Would named pipes be the best solution?

How to organize dozens of excel reports into 1 solution?

Goalie3516-Jan-08 5:27

Goalie35

16-Jan-08 5:27

I'm looking for some organizational tips on the best approach to organize our company's c# excel reports and was curious how some of you handled this task.

Currently, we create dozens of reports via c# console applications using the "microsoft office 11.0 object library". We then simply schedule them to run at a certain time (daily, weekly, monthly).

Yesterday, we had a meeting however, and realized we now have dozens of these report projects all over the place, spread out among 5 different developers and nobody really knows who's working on which reports. So we've decided to look into creating a single, clean solution to handle ALL reports.

So I'm just looking for some ideas as to the best approach to take with this in order to keep everything organized AND where any developer could jump into another developers report project in their absense.

Thanks.

-Goalie35

Re: How to organize dozens of excel reports into 1 solution?

martin_hughes16-Jan-08 8:15

martin_hughes

16-Jan-08 8:15

Some kind of database seems appropriate - maybe even SQL Server Reporting Services[^]?

Probably an easy Regex question

Andrew Stampor16-Jan-08 5:14

Andrew Stampor

16-Jan-08 5:14

This is probably something easy for someone who is experienced with Regex and regular expressions in general. Unfortunately, I am not one of those people. Perhaps one of you kind souls will take pity on me and help me out here.

I need to replace a part of a string with another string. I only want to replace the first instance. An example of the the beginning of the string being searched is as follows:

<chart first_node_id="None" item_id="323f359f-f2db-4cd5-b779-aebc1349d587" form_type="None" name="here is an old name" last_modified="1/16/2008 11:03:33 AM"><br />
  <node name="don't change this name" node_id="ff918de6-213d-4a11-8c1c-ce5b54c7d8f2" result="None"

What I want to find and replace is the "here is an old name" part. Note that 'name=' is repeated, and I only want the first one replaced.

I've tried several different expressions, but the one I am currently toying with is as follows:

<br />
Regex regExp = new Regex("name=\"(.*)\"");<br />
string test = regExp.Replace(oldString,newName,1);<br />

This doesn't do what I want. It finds 'name="here is an old name" last_modified="1/16/2008 11:03:33 AM"' and replaces the whole thing instead of just what is between the quotation marks.

I've been trying to read up on reg expressions and Regex, but the time crunch I am under is making me impatient and it is hard to learn with that mentality. So, any help you can provide would be most appreciated. Thanks in advance.

Re: Probably an easy Regex question

TJoe16-Jan-08 7:44

TJoe

16-Jan-08 7:44

You need to use a "non-greedy" or lazy flag on the .* part. So it would be .*?

It is documented here[^].

Take care,
Tom

-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com

Re: Probably an easy Regex question

Andrew Stampor16-Jan-08 7:54

Andrew Stampor

16-Jan-08 7:54

I thought I had tried the lazy flag, but it seems to have fixed my issue. Thanks!

Re: Probably an easy Regex question

martin_hughes16-Jan-08 10:57

martin_hughes

16-Jan-08 10:57

Another tip for you - download Expresso[^] if you haven't already as it makes working with RegEx's much simpler.

SQL Server pool size

DannyAdler16-Jan-08 3:41

DannyAdler

16-Jan-08 3:41

Hi all,

Is there a C# way for retrieving the number of currently opened sql-connections?

Thanks in advance,
Danny

Re: SQL Server pool size

Justin Perez16-Jan-08 3:53

Justin Perez

16-Jan-08 3:53

DannyAdler wrote:
Is there a C# way for retrieving the number of currently opened sql-connections?

Yes. The SQL query to return the connections is:

select * from sys.dm_exec_connections

I suggest you create a stored procedure in your database, and call that SP from your C# app.

I'm going to become rich when I create a device that allows me to punch people in the face over the internet.

"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer

Re: SQL Server pool size

DannyAdler16-Jan-08 4:15

DannyAdler

16-Jan-08 4:15

Thanks for the reply man.

Here's the query result:
Invalid object name 'sys.dm_exec_connections'.

Using SQL Server 2000...

Any idea?

Danny

Re: SQL Server pool size

Justin Perez16-Jan-08 4:34

Justin Perez

16-Jan-08 4:34

Works fine for me. I ran it from code, and I just opened up a SQL Query in SQL Server Management Studio Express and ran it. Would you post the code you are using to execute the query? I'm looking to see if that exists in SQL 2000.

Re: SQL Server pool size

DannyAdler16-Jan-08 21:02

DannyAdler

16-Jan-08 21:02

No code...
Just by running your query on the Enterprise Manager and on the Query Analizer apps.

Maybe it's a version thing.

Danny

Re: SQL Server pool size

DannyAdler16-Jan-08 4:24

DannyAdler

16-Jan-08 4:24

Found it on this dude's blog:
http://sqljunkies.com/WebLog/sqldude/archive/2004/06/14/3146.aspx[^]

Quoting:
Now to obtain the current number of connections to the server, you can use:

SELECT COUNT(*) AS CONNECTIONS FROM master..sysprocesses

And just to get the user connections, omitting the system processes, use:

SELECT cntr_value AS User_Connections FROM master..sysperfinfo as p
WHERE p.object_name = 'SQLServer:General Statistics' And p.counter_name = 'User Connections'

Thanks anyway.

Danny

Tiff to AVI

Ylno16-Jan-08 3:06

Ylno

16-Jan-08 3:06

Hello All,

Has anyone come across any code that will convert a set of tiff files to an avi?

Thanks.....

Check if a Bitmap has tranparency

DannyAdler16-Jan-08 2:43

DannyAdler

16-Jan-08 2:43

Hi all,

So I have a Bitmap field, now I want to save it to disk, BUT if it has
some transparent pixels, I want to save it as a gif, else save as
jpg.
Sounds reasonable?
How can I do that?

Thanks in advance,
Danny

Re: Check if a Bitmap has tranparency

Christian Graus16-Jan-08 9:20

Christian Graus

16-Jan-08 9:20

There is no such thing a transparent pixels in a bitmap. There's only transparency support in file formats, and in code that sets bitmasks.

The png file format has transparency built in, but when you load a bitmap object it doesn't have support for transparency, it's just not part of the format.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: Check if a Bitmap has tranparency

DannyAdler16-Jan-08 23:06

DannyAdler

16-Jan-08 23:06

Okay, so maybe my approach is wrong..

Situation:
The user opened an image file, and I load it to a Bitmap, but I don't know if the image has some transparent regions.
Now, regardless to the original user's image file's format, I want to save the image to disk, Image.Save (String, ImageFormat).
So if the original image had some transparent regions, I would want to use an ImageFormat that has support for transparency (png/gif), and if there were no transparent regions, I would use Jpeg.

Questions:
Does this requirement make sense?
How can I handle this kind of situation?

Thanks,
Danny

Display comboBox in usercontrol property

Peterson Luiz16-Jan-08 2:23

Peterson Luiz

16-Jan-08 2:23

Hello,

I have a userControl that has a string property. I want that, instead of typing in this property, the user gets a comboBox with strings got from a database.
I've created a new class that has a GetStandardValues method, like this:

public override System.ComponentModel.TypeConverter.StandardValuesCollection GetStandardValues(ITypeDescriptorContext context)
{
ArrayList permissions = new ArrayList();
permissions.Add("test1");
permissions.Add("test2");
permissions.Add("test3");

return new StandardValuesCollection(permissions);
}

When I set the typeConverter of the property at my userControl to be the type of the above class, it works. The control's property diplays the test strings in a comboBox.
But when I try to bring this strings from a dataBase, it doesn't work.

I've already tried this:

public override System.ComponentModel.TypeConverter.StandardValuesCollection GetStandardValues(ITypeDescriptorContext context)
{
ArrayList permissions = DataBase.GetPermissions();
return new StandardValuesCollection(permissions);
}

Anybody has can help me?

Thanks

Peterson

Re: Display comboBox in usercontrol property

Justin Perez16-Jan-08 3:16

Justin Perez

16-Jan-08 3:16

Peterson Luiz wrote:
When I set the typeConverter of the property at my userControl to be the type of the above class, it works. The control's property diplays the test strings in a comboBox.
But when I try to bring this strings from a dataBase, it doesn't work.

What do you mean "it doesn't work?" Does it throw an error, does it return nothing? When posting a question be as descriptive as possible.

Peterson Luiz wrote:
I've already tried this:

public override System.ComponentModel.TypeConverter.StandardValuesCollection GetStandardValues(ITypeDescriptorContext context)
{
ArrayList permissions = DataBase.GetPermissions();
return new StandardValuesCollection(permissions);
}

Anybody has can help me?

Have you tried setting a breakpoint on the return to see what the values in your permissions ArrayList? If it doesn't throw an error, maybe you aren't returning anything from your database.

Re: Display comboBox in usercontrol property

Peterson Luiz16-Jan-08 4:34

Peterson Luiz

16-Jan-08 4:34

Hello,
When I said it doesn't work, I get an NullReferenceException. But, if I put the same code somewhere else and try it in runtime, it works perfectly. It returns all the strings I want from the database. So, the code is right, but doesn't work in design mode, with the usercontrol.

I get the NullReferenceException at the line
ArrayList permissions = DataBase.GetPermissions();

Thanks

Peterson

Re: Display comboBox in usercontrol property

Gareth H16-Jan-08 12:07

Gareth H

16-Jan-08 12:07

Peterson Luiz,

I think you just answered your own question. By the sounds of it, you're trying to view information in design mode when you don't have a database connection.

Either, put the below at the top of your method to stop the method accessing the database:

If (DesignMode)<br />
 return;

OR. When ever you call the object DataBase, check if its null and create a new instance.

Regards,
Gareth.

Which ADO.NET DataProvider to use?

Blumen16-Jan-08 2:19

Blumen

16-Jan-08 2:19

Hi,

How do we decide which data provider to use from ADO.NET?

How do I decide if I need to use SQLClient or Oledb data provider for my SQL Server database.

The answer that I got for this question from my collegues is that "coz SQL Client is optimized to be used for SQL Server", is that the only reason?

Regards,
Blumen

Re: Which ADO.NET DataProvider to use?

Gareth H16-Jan-08 2:37

Gareth H

16-Jan-08 2:37

Hi Blumen,

Yes, the SQL set of classes are designed for SQL Server and the OleDb are for Access.

Regards,
Gareth.

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