|
Hi,
this[^] says you shouldn't close and immediately reopen a serial port.
suggestion: check the port settings; if no change needed simply clear in- and out-buffer and go on; otherwise include a sleep.
BTW: why are you parsing integer parameters such as baudrate?
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
Hi,
Thanks for your answer. Ok, I will try the sleep. Interesting link you sent.
What I am worried about is that once it's locked into the:
ERROR The I/O operation has been aborted because of either a thread exit or an application request.
Port Open Failed.
it seems to stay there even if I start and stop my application again (both in dev environment in debug config, and using a released exe). The only way to unlock it is by opening and closing the port with hyperterminal. I wonder how I might be able to do this programatically?
Is there any ways to run a batch file to open and close a hyperterminal? It's not the best solution but will have to do for a quick-fix...
Thanks,
Charlie
|
|
|
|
|
I seem to have solved the issue by modifying my ClosePort sub to:
Public Sub ClosePort()
bAllowSndRcv = False
If IsNothing(comPort) Then Exit Sub
If comPort.IsOpen Then
comPort.DiscardOutBuffer()
RemoveHandler comPort.DataReceived, AddressOf comPort_DataReceived
Threading.Thread.Sleep(200)
comPort.Close()
End If
End Sub
|
|
|
|
|
Hi All
I am getting a problem in merging two datasets into one. Both datasets have the same schema, structure but different data. One of the datasets have data with null values in some columns. But I want them to merge and the final result should be that one of the dataset has all the rows.
Fyi, the two datasets were populated with data from excel files. Both excel files have same columns. But they can have null values in some of the columns.
Please help me to resolve this issue.
sri
|
|
|
|
|
Hi , have a good day
I am going to tell you something a little bit closer to your problem
Once I exported an Excel file to MS SQL server database
and when I call SQLDataReader it's throw Exception at null value
so I apply this Query on every sql table Column to Avoid this problem
UPDATE tbmain set customername = '' WHERE customername IS NULL
NULL is not ''
hope this help
kind regards ...
I know nothing , I know nothing ...
|
|
|
|
|
do the tables have "not null" on the destination table where the null values from the source table appear?
and do you want the rows with the NULLs?
|
|
|
|
|
Hi all,
I am doing windows applicaiton which has three columns such PID,ProcessName and Select, I have done check boxes for the select column.But now my need is
i want to add a check box in header, and enabling the checkbox change event.
i am using Datagridview control in C#, visual studio 2005.
Can some one help me out... pls urgent...
thanks in advance.
|
|
|
|
|
|
Hello All,
I hope this is the correct forum, please excuse me if it is not.
I am new to VS/C#. I have managed to make a simple service and MSI installer for it. What I need to do is make a change to the msi to read 3 command line arguments and record them in either the apps configuration file for the installed service or record them to the registry. If to the registry, I can change my service to read from it.
The installer project does not have an obvious code (*.cs) page, so I am unsure how to proceed.
Thanks!
cjoki
|
|
|
|
|
|
Thanks mark...I am reading material now and running the SDK download to get Orca. To bad MS does not have that in a separate download...oh well.
I will post my results later.
|
|
|
|
|
the author looks to make a number guesses about the inner workings of the wid file structures....still reading the link but I recall seeing something on WiX, a series of tools and xml file used to make a msi file, does anyone have experience with this and would this also be able to meet me requirements?
|
|
|
|
|
Hi,
I've files stream (basically an excel file) and that can be walk through as rows and columns (dataset) ? if so please sample if you have anything or tell me the steps that i need to follow.
Thanks
|
|
|
|
|
Im little bit confused, What you really want to do?
Thanks
Md. Marufuzzaman
Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
I've voted one for your message, here is why:
1) You haven't told us what you have tried.
2) Asking for a sample immediately is bad form, especially as you seemingly haven't tried anything
3) You can easily type "c# read excel file" into good and get lots of starting points.
CCC solved so far: 2 (including a Hard One!)
|
|
|
|
|
and your question makes no sense what-so-ever.
|
|
|
|
|
Hi,
I am using BMC AR remedy client 7.1. I have deloped an application in C# to fetch data from some tables of this database. The problem is that I am not getting the data for some rows for which value is a large string.
I tried using OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0) API's to fetch data. Both of them fails if the value is a large string. Also, it doesn't timeout and the execution stays at this call only and application used to hang.
There is a inconsistency in the output of the query for different records. For some records, it works fine and for some data is missing and for some the same query hangs.
Eveything was working fine for the AR REmedy client 6.20. Only after upgrading it, I started getiing this problem.
- Is there a better way to fetch data from a ODBC database through C#?
- How to set a timeout value for the query execution so that the application dowe not hang?
Thanks in advance.
- Praveen
P.S
Connection string: "Driver={AR System ODBC Driver}; arserver=**********; arserverport=*******; uid=******; aruseunderscores=*******; server=******";
Query: SELECT cloumn1 FROM tablename WHERE column1.value='00000';
Praveen Raghuvanshi
Software Engineer,
India.
|
|
|
|
|
Rags1512 wrote: Eveything was working fine for the AR REmedy client 6.20. Only after upgrading it, I started getiing this problem.
Then the best course is probably to get in touch with the supplier - not likely that anyone here would be able to help.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
I contacted the supplier and was told that earlier they were using SQL server and they have moved to Oracle.
Will this make a change.
Also, my 2 questions remain unaswered
- Is there a better way to fetch data from a ODBC database through C#?
- How to set a timeout value for the query execution so that the application does not hang? i.e how to avoid execution of OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0) API's infinitely?
Thanks,
Praveen
Praveen Raghuvanshi
Software Engineer,
India.
|
|
|
|
|
Yeah, use the provider for the database engine you're connceting to. ODBC is the "generic" provider and it's data types may not match up to nor work 100% with the database engines native data types.
If your connecting to an Oracle database, look into reading this[^].
|
|
|
|
|
Thanks, still I have some query.
I tried to fetch data from the database using MS Excel and it worked fine. Also, tried with VB, the results are as expected. It fails/retrieves less no of records with the queries using OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0).
- How to set a timeout value for the query execution so that the application does not hang? i.e how to avoid execution of OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0)?
- Is there a manual way to fetch data in C# rather than using the APS's?
Thanks,
Praveen
Praveen Raghuvanshi
Software Engineer,
India.
|
|
|
|
|
Rags1512 wrote: I tried to fetch data from the database using MS Excel and it worked fine. Also, tried with VB, the results are as expected. It fails/retrieves less no of records with the queries using OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0).
Like I already said, don't use ODBC.
Rags1512 wrote: - How to set a timeout value for the query execution so that the application does not hang? i.e how to avoid execution of OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0)?
I hate repeating myself.
Rags1512 wrote: - Is there a manual way to fetch data in C# rather than using the APS's?
Whatever you mean by "APS", no.
|
|
|
|
|
Good morning.
I was wondering if there was an easy way to access the list of folders and subfolders from a SharePoint site.
I have the following so far:
namespace SharePoint_Tree
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
teamspace.Lists tsl = new teamspace.Lists();
tsl.Credentials = CredentialCache.DefaultCredentials;
XmlNode resp = tsl.GetList("Content and Structure Reports");
this.Response.Write(resp.OuterXml);
}
}
}
Thank you, WHEELS
|
|
|
|
|
You might get more response if you post this in the SharePoint forum. here[^].
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.”
modified on Monday, October 12, 2009 10:46 AM
|
|
|
|
|
Wheels012 wrote: an easy way to access the list of folders and subfolders from a SharePoint site.
Yes there is, ask in the correct forum and you might get an answer, or be told it's so simple it should take about 30 seconds to Google it.
only two letters away from being an asset
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
