Re: Database access error - C# Discussion Boards

Alex Korchemniy16-Oct-04 8:42

16-Oct-04 8:42

You have the values. Now just loop and use DrawLine(); Based on the value calculate so that you have a different line height. Increase your X value and continue for the next value.

If this doesn't work for you - you might end up having to use SetPixel method.

This posting is provided "AS IS" with no warranties, and confers no rights.

Alex Korchemniy

Re: How to draw a custom graph/2D plot?

Kiran Satish16-Oct-04 18:23

Kiran Satish

16-Oct-04 18:23

Hi,

i can understand ur code... but the problem is...

I have developed a Windows form Project in C# and in tht i am opening different bitmap images....now in tht when a bitmap is active and the user selects a menu button "Histogram"... i have to display the histogram of tht image in a seperate window. So i have to initialise a new window(form) and i have to display the histogram(plot), which i don't know how to do tht...

Hope i am clear now... if u have any ideas plz share with me...

thanks,

Suman

Resource Globalization

codes/w15-Oct-04 19:07

codes/w

15-Oct-04 19:07

Hello all,

Tell me, what is Resource Gloablization? and how is it work? Give me example to it.

Re: Resource Globalization

Alex Korchemniy16-Oct-04 10:00

Alex Korchemniy

16-Oct-04 10:00

Globalization refers to making your application usable in other languages.

You can start by setting the Localizable property of your Form to true, and selecting a value for Language. Behind the scenes VS.NET create resource files for each language. These resource files have all the values that you set for the language. The culture-specific resource files are commonly packaged in satellite assemblies for each culture.

For more information see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemresourcesresourcemanagerclasstopic.asp[^] and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemresourcesresourcemanagerclassgetstringtopic.asp[^]. This might be helpful: http://www.codeproject.com/dotnet/Localization.asp[^]

This posting is provided "AS IS" with no warranties, and confers no rights.

Alex Korchemniy

How to use the play list function of the

skywen15-Oct-04 17:47

skywen

15-Oct-04 17:47

DirectShow.

in the other word how can i play multi-file once?

thanks!

Database access error

StephenMcAllister15-Oct-04 16:11

StephenMcAllister

15-Oct-04 16:11

Hi All,

I am connecting to a SQL 2000 Server database by using a datareader.

I am getting this error.

An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll

Additional information: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

1. How can I lengthen the time out on my connection?
2. How can I make sure there are no connections and that all connections are released by me and returned to the pool?

Thanks for any help.

Stephen

Re: Database access error

Carl Mercier15-Oct-04 17:14

Carl Mercier

15-Oct-04 17:14

It would help if you could provide us with some code, and where the exception occurs.

Re: Database access error

Alex Korchemniy16-Oct-04 10:13

Alex Korchemniy

16-Oct-04 10:13

1.) Look at this: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassconnectiontimeouttopic.asp[^]

2.) The following code ensures that the connection is disposed properly. Also if you have a transaction open and something goes bad the rollback is ensured. Smile | :)

using(SqlConnection con = new SqlConnection())<br />
{<br />
  con.Open();<br />
  // Do work here<br />
}

This posting is provided "AS IS" with no warranties, and confers no rights.

Alex Korchemniy

C# interop with type System.__ComObject?

vista2715-Oct-04 15:01

vista27

15-Oct-04 15:01

is there anything special that needs to be done when interopping with objects of type System.__ComObject? without good docs, how do you know what to cast to if all u got is a C# type object?

Re: C# interop with type System.__ComObject?

Heath Stewart15-Oct-04 15:50

Heath Stewart

15-Oct-04 15:50

It greatly depends on what you're doing. All types (doesn't matter which language, BTW) are IDispatch implementations unless you expose an interface differently using different enums for either the InterfaceTypeAttribute<?code> (for interfaces) or <code>ClassInterfaceAttribute (auto-generated class interface; never use auto-generated class interfaces, though).

When you cast an object to a COM-defined interface (attributed with ComImportAttribute) a QueryInterface is actually performed using the interface to which you're trying to cast. This means you have to have some idea of what you're trying to cast, otherwise you can either cast it as IDispatch (if it's a dispatch object) or - at the very least - IUnknown, which honestly gives you anything useful.

As I've told many people, understanding COM interop with .NET well requires that you understand COM well. I would recommend picking up a book on COM programming, as well as a book on COM interop if you need further explanation.

There's also several good articles here on this site that explain bits and pieces, but the bigger pictures requires a deeper understanding of just how COM works and how .NET interop works with (and for) COM.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

Posting a File on a Form

Member 138504915-Oct-04 11:27

Member 1385049

15-Oct-04 11:27

Hello,
I am trying to output a txt file to a Windows form in C# of course. I have coded how to read the file, that is not a problem anymore. And I can outpout it to the console. But I have been unsuccessful on how to output it on a Form instead of a console.
Can anyone help please?

A Newbie in tha block

Re: Posting a File on a Form

Alvaro Mendez15-Oct-04 11:41

Alvaro Mendez

15-Oct-04 11:41

Add a control (such as the Label or TextBox) to the form and set its Text property to the contents of the file.

Regards,
Alvaro

Our enemies are innovative and resourceful, and so are we. They never stop thinking about new ways to harm our country and our people, and neither do we. - George W. Bush

Re: Posting a File on a Form

Member 138504915-Oct-04 15:33

Member 1385049

15-Oct-04 15:33

Thank you Alvaro for your response,
I am writing a program that reads records from a file of type txt containing stuffs like item name, quantity and prices. The first step is to simply read the file and output its containt on a windows form. The second step will be to compute the total cost of each item and post it the results on the form. I guess I have figured out how to do this second part ( well, i guess). But I am stuck on the first step.
This is what I have:
I have the class, reading the txt file, called PartFile. This class contains this function that is supposed to read the file (maybe typecast everything to string) and sent it to the Form.

public void ReadFile()
{
string line;
StreamReader file = new StreamReader("MyFile.txt");
while((line = file.ReadLine()) !=null)
//Console.WriteLine(line); ///commented out because I want to write the file to a Form, not Console
file.Close();
}

While reading my C# book I read about a ToString function, how can I implemente it here to read the file as strings?
Is that how I should code this function, is there anything I should do? how should I do it? Please, help me think through this.I got a brain storm now....can't find a way to get to the next level that I feel i can pretty much do. I just need to be able to read the file and post it to a form. I kind feel like i can move forward on my own (maybe) right after.
Thank, and i hope someone will help... Thank you Alvaro

A Newbie In Tha Block

Re: Posting a File on a Form

Alvaro Mendez15-Oct-04 21:27

Alvaro Mendez

15-Oct-04 21:27

Do this instead:

StreamReader file = new StreamReader("MyFile.txt");<br />
string contents = file.ReadToEnd();<br />
file.Close();

That's it, now you have the whole contents of the file in one string. Add a Label control to your form and do:

label.Text = contents;

Regards,
Alvaro

Our enemies are innovative and resourceful, and so are we. They never stop thinking about new ways to harm our country and our people, and neither do we. - George W. Bush

.NET Remoting Reference

Wender Oliveira15-Oct-04 9:45

Wender Oliveira

15-Oct-04 9:45

I have a class Client (client.cs) that is serializable and a class RemoteMethods (MarshalByRefObject) with a method public static Client getClient(int clientID). Ok... now the question... how to add a "remote" reference to Client class. I want to access this class without need to have the Client's dll on my client side I want to access this referencing it on another machine... This is possible?

Regards....

Wender Oliveira
.NET Programmer

Re: .NET Remoting Reference

Alex Korchemniy15-Oct-04 10:10

Alex Korchemniy

15-Oct-04 10:10

Please clearify...

Wender Oliveira wrote: without need to have the Client's dll on my client side.

And another thing

Wender Oliveira wrote: how to add a "remote" reference to Client class

If you are trying to reference something in the client assembly from the server assembly your design is not right. That class must be in the shared assembly.

Confused | :confused:

Re: .NET Remoting Reference

Wender Oliveira15-Oct-04 10:15

Wender Oliveira

15-Oct-04 10:15

Sorry... lol
I want to make a new instance of a class that exists only on my remote server... I don't want to copy the dll that has this class inside to my client server...

Wender Oliveira
.NET Programmer

Re: .NET Remoting Reference

Alex Korchemniy15-Oct-04 10:20

Alex Korchemniy

15-Oct-04 10:20

OK. That's more like it. Smile | :)

What you do is you create a library that has that class you want to use in both the client and the server. You then add a reference to the library in both the server and the client.

Another thing. If you want to have the implementation for the code hidden you can create an interface that matches the code (its a good practice to come up with the interface before hand Smile | :)

) and put the interface in the shared library.

Re: .NET Remoting Reference

Wender Oliveira15-Oct-04 10:24

Wender Oliveira

15-Oct-04 10:24

Thanks Alex... This is what I want to know but not what I want to read. I'm doing like you said and I was hopeful to find another way... like webservice... you just add a web reference and all those classes can be found by vs.net ...

Thanks again...

Wender Oliveira
.NET Programmer

Re: .NET Remoting Reference

Alex Korchemniy15-Oct-04 10:29

Alex Korchemniy

15-Oct-04 10:29

Yeah WS work differently. They use WSDL to describe how the WS works. There is a tool call soapsuds.exe if you are hosting your remoting object using HTTP and Soap you can use it to generate an interface assembly. I've ran across this when getting my MCAD but you'll have to look into it more.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cpgrfsoapsudsutilitysoapsudsexe.asp[^]

This posting is provided "AS IS" with no warranties, and confers no rights.

Alex Korchemniy

Change the caret color in a textbox

ee9903515-Oct-04 7:30

ee99035

15-Oct-04 7:30

How can i change the caret color in a textbox?!! Is it possible?!

Thanks

Re: Change the caret color in a textbox

Alex Korchemniy15-Oct-04 9:47

Alex Korchemniy

15-Oct-04 9:47

I'm looking for the same thing. Well not really looking but I need a solution. Dont have time to look Blush | :O

Re: Change the caret color in a textbox

Carl Mercier15-Oct-04 17:13

Carl Mercier

15-Oct-04 17:13

Not sure if it helps... but here's some VB6 code I found on the groups:

http://groups.google.com/groups?hl=en&lr=&safe=off&selm=u5toJi9KBHA.1440%40tkmsftngp07[^]

slow listview refresh

DF_Bandit15-Oct-04 6:49

DF_Bandit

15-Oct-04 6:49

I have a listview in detail mode which I use to display a subset of records from an SQL table. If the user changes the subset parameter I refresh the list with another set of lines.
My problem is that while the original population of the list is very fast (it is done in the dialog's constructor), the refreshes are quite slow - about 10 seconds for a 500 line data set.
I know the problem lies with the listview since if I comment out the listview code, the method executesd quite fast. I have tried:
begin/end update
setting enable=false and then true
setting visible=false and then true
None seem to have more than a small effect (about 10% difference).

Any suggestions?

the method's code:

...<br />
sqlCmd.CommandType = CommandType.StoredProcedure;<br />
SqlDataReader reader = sqlCmd.ExecuteReader();<br />
<br />
lvwLogDays.Items.Clear();<br />
      <br />
while( reader.Read() )<br />
{<br />
	DateTime Date = reader.GetDateTime( reader.GetOrdinal( "LogDate" ) );<br />
	string strTemp = Date.ToString( "MM/dd/yyyy" );<br />
	OpenDayLogData	DayLogData = new OpenDayLogData();<br />
<br />
	ListViewItem item = lvwLogDays.Items.Add( strTemp );<br />
        strTemp = reader["CallLetters"].ToString().Trim();<br />
        item.SubItems.Add( strTemp );<br />
<br />
	strTemp = reader["LogStatus"].ToString().Trim();<br />
        item.SubItems.Add( strTemp );<br />
<br />
	DayLogData.LogID = Convert.ToInt32(reader["DF_LogID"].ToString(), 10);<br />
	DayLogData.LogDayID = Convert.ToInt32(reader["DF_LogDayID"].ToString(), 10);<br />
        item.Tag = DayLogData;<br />
}<br />
...

Re: slow listview refresh

Heath Stewart15-Oct-04 7:00

Heath Stewart

15-Oct-04 7:00

Calling ListView.BeginUpdate before clearing and adding items, and ListView.EndUpdate should help performance quite a bit.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

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