|
i want to catch the exception for the network failure what is the exception for this ?
|
|
|
|
|
There is no single exception. There can be a mariad of problems causing different exceptions at different stages of connecting and executing a query.
|
|
|
|
|
yrkl wrote: what is the exception for this ?
Did you try this one?[^]
|
|
|
|
|
Network failures usually get TCP exceptions. Usually when I want to test a network failure adequately I yank the cable in debug mode.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
If you don't ask questions the answers won't stand in your way.
Most of this sig is for Google, not ego.
|
|
|
|
|
Definitely; there's no data like emperical data.
|
|
|
|
|
I'm working on a program for some of my coworkers that take inventory with hand held scanners. I've been able to download the text file from the scanner and play around with that, but now I'm to the part where the users need to be able to view, edit, and update the records because sometimes the data isn't always accurate. I'm trying to set this up where the records are saved in an excel file. Using an OleDB data adapter I can access the xls file and place it nicely into the gridview, and I'm sure with a little bit of elbow grease I'll be able to wire up the events to update and save the modifiled cells back. My question here is, is there a better way to do this? For example, is there a way in which I can just start excel.exe and embed it into my windows form instead of using OleDB?
Thanks everyone!
"You're damned if you do, and you're damned if you dont" - Bart Simpson
|
|
|
|
|
Might you not use some sort of database at the back end instead of Excel?
Regards,
Rob Philpott.
|
|
|
|
|
Hi Rob,
I thought of just using a SQL server at first, but one of my objectives is to give the users the ability to export everything to an excel document. That's why I figured It would make the most sense to just read and write straight to the xls file rather than first importing everything into SQL to then turn around, read it all back out and then write it to the xls.
I think what I will eventually do is just use System.Diagnostic.Process to start up excel opening the file after I've done what I need to do with it.
"You're damned if you do, and you're damned if you dont" - Bart Simpson
|
|
|
|
|
Excel makes for a lousy database. There's a limited number of rows you can put into an Excel sheet, and there is also the constraint of memory. You may eventually find out you made a mistake by going with Excel.
|
|
|
|
|
Hi Dave,
Ah, I was unaware of the row limitations. Thanks for the warning. To make sure I don't cramp my programs room for growth I've decided to go with a SQL database and just add a button to allow the users to export the gridview to excel.
"You're damned if you do, and you're damned if you dont" - Bart Simpson
|
|
|
|
|
Most of the times, "Export to Excel" as a requirement is made by persons who have no understanding of technical issues. Which is a bonus for programmers in this case, it is trivial to export to CSV and 99.99% of end-users don't know the difference and those that do don't care. With that issue out of the way embed into SQL Express, it will make your life easier.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
If you don't ask questions the answers won't stand in your way.
Most of this sig is for Google, not ego.
|
|
|
|
|
Greetings all,
I was curious if anyone knew how one would go about graphing data recieved from a serial port via rs232 in real time. I would just like to have a 2d line graph that would update upon every byte recieved from the serial port. The graph can have a static range as well, say from 0-255.
Any help would greatly be appreciated.
|
|
|
|
|
|
I should have said this in the first post, but I already have established a working com connection. I can send/recieve data through the port. What I really need help with is graphing the data.
With the custom control overriding, how exactly does that work? WOuld you be able to provide me with a sample code?
|
|
|
|
|
There are numerous articles on Code Project dealing with custom drawing in OnPaint for controls. The event argument contains a Graphics object which is very easy to use just by looking at the method signatures.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
If you don't ask questions the answers won't stand in your way.
Most of this sig is for Google, not ego.
|
|
|
|
|
I will do some more research. thank you for the advice on the custom drawing controls.
|
|
|
|
|
|
Thanks for the link. Have you used ZedGraph before?
|
|
|
|
|
Yes I am using it now for some data graphing.
It is Open Source and it has lots of potential. Another possible solution might be .. MS released a chart control a month or 2 ago. I've tried it but for what I'm doing there was just to much overhead but it might be worth giving it a shot.
Hope This Helps
Rafone
Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...
|
|
|
|
|
|
The following snippet is intended to read the current maximum value and increment it by 1 so that it uses it to store in the database.
I need to convert the result of rawValue to an integer, increment it by 1, an, include it as a parameter.
any ideas?
object rawValue = getTaskRefSQL.ExecuteScalar();
if (rawValue != DBNull.Value)
{
myValue = (System.Data.Sqltypes.SqlInt64) rawValue;
myValue++;
}
cmdCreateNewTaskQuery.Parameters.AddWithValue("@taskID_PK", myValue);
Jon
|
|
|
|
|
myValue = (long) rawValue;
Using this method to create your primary key isprone to errors, use an auto-incrememnting identity field where possible.
|
|
|
|
|
this works good for me...int.Tryparse will try and convert to an integer, returning true if it succeeds and false otherwise, you can probably do long etc too
here i feed in a string, and try to convert to an int...
booResult = (int.TryParse(strSpO2, out intSpO2));//feed in string, and request an int out
if (booResult == true)//then it is numeric
|
|
|
|
|
Is there a way to change the horizontal arrow symbol position in a sortable ListView column header? I want the arrow to be closer to the header text.
|
|
|
|
|
Good Morning/Afternoon/Evening,
I'm trying to copy the contents of an unbound DataGridView of one form into an unbound DataGridView on it's child form. I've been looking all over for a solution, but I can't figure the darn thing out. It should be a simple task, should it not?
Please help!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
