|
Thanks BP,
Not the answer I was hoping for but I now understand the situation and can move ahead.
SMW
|
|
|
|
|
You can probably have another program to an existence test before running the application.
|
|
|
|
|
Hi All,
I develop a windows form to read excel file using oledbconnection, my problem is when any column header in excel file contains dot (.), such as customer.Name I get the following error:
" Invalid bracketing of [Customer.Name] ".
Please help me to solve this problem and how to remove . from the columns.
Thanks for your effort
|
|
|
|
|
Show us the relevant code snippet!
|
|
|
|
|
HI,
This is the code:
Hi,
this is the code:
string conString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=filepath;Extended Properties=Excel 12.0 XML;HDR=Yes;IMEX=1;MaxScanRows=0;";
OleDbConnection con=new OleDbConnection(conString);
con.open();
OleDbCommand command = new OleDbCommand("select * from [sheet1$]", con);
OleDbDataReader reader = command.ExecuteReader();
DataTable dt=new DataTable();
dt.load(reader);
con.close();
Thanks
|
|
|
|
|
I just tried that and the dot got changed to a hash (#) character.
|
|
|
|
|
Hi ,
this is my code, please let me know if there is any problem in it.
string conString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=filepath;Extended Properties=Excel 12.0 XML;HDR=Yes;IMEX=1;MaxScanRows=0;";
OleDbConnection con=new OleDbConnection(conString);
con.open();
OleDbCommand command = new OleDbCommand("select * from [sheet1$]", con);
OleDbDataReader reader = command.ExecuteReader();
DataTable dt=new DataTable();
dt.load(reader);
con.close();
|
|
|
|
|
Sorry, it still works for me, there must be some other problem in your code.
|
|
|
|
|
The code you have given us looks ok - so it's time to look at your data.
What does the row giving the problem look like?
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
I think it's not the data, but the columns name; as soon as it gets mapped, it'll recognize the illegal name. It'll be valid in Excel, but not in a real database.
Simple solution; rename the column, remove the dot.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Could be - but I'd expect OleDb to cope better than that.
Be good to see the actual data so we can duplicate the fault.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
HI, I am working on a project in which I have to make calls to mobile phone through USB dongle(Netsetter) I am using Huawei E1550 modem,I have done the calling part using AT commands but the modem is not supporting for voice,means I am not able to send the voice, please guide me which USB modem I should use that supports voice please help me in this matter, my modem gives error to AT+FCLASS=8 which is the voice enable.
|
|
|
|
|
Following words in google seem to return results that suggest which modems do it.
usb modem voice
|
|
|
|
|
I have a winform and a picturebox.
In the picturebox I´m running a XNA-game.
In the winform I have:
Game1 game = new Game1();
public Game1 Game
{
get
{
return game;
}
set
{
game = value;
}
}
In the XNA-form I try
public Form1 form = new Form1();
public Form1 Form
{
get
{
return form;
}
set
{
form = value;
}
}
I can via methods send info to the game using:
game.StartBoat();
where StartBoat is a method in my XNA-game.
I would like to send info to the winform also.
But I get a stackoverflow exception indicating an infinite loop. How should I do it if possible?
|
|
|
|
|
That code does not make much sense, in both cases the get and set would seem redundant.
|
|
|
|
|
Richard MacCutchan wrote: That code does not make much sense, in both cases the get and set would seem redundant.
Well, I´m not a superexpert in C# and certainly not XNA so I have got a lot of help via forums.
|
|
|
|
|
If one of those is responsible for creating the other, don't new up the original one in the new one. So, if Form1 creates Game1, don't do new Form1() in Game1. That will clear your stack overflow.
Now, as to the second part of your problem. There are a few things you could do to get around this. The first method is to pass a reference to Form1 into the1 Game constructor (or explicitly set it at some point before you try to use Game).
public class Game1 : Game
{
private Form1 form;
public Game1(Form1 form)
{
this.form = form;
}
}
public class Form1 : Form
{
private Game1 game;
public Form1()
{
game = new Game1(this);
}
}The other way to do this, and the way I tend to prefer, is to use events in Game1 to signal that Form1 should do something. By using events, you decouple Game1 from having to know anything at all about Form1 - which means you could swap it into other projects far easier. Basically, after you instantiate Game1 in Form1, you can subscribe to the events that you're interested in and use those as appropriate.
|
|
|
|
|
|
|
Hi ,
Please help me to make a chart like this to use in WPF. Is there any charts available for this.On clicking the data points , I should get corresponding values.
http://i.stack.imgur.com/M1QYL.png[^]
With warm regards
Subin
|
|
|
|
|
|
CodeProject is your friend: [^].
Once you get started, please come back with any specific questions.
“The best hope is that one of these days the Ground will get disgusted enough just to walk away ~ leaving people with nothing more to stand ON than what they have so bloody well stood FOR up to now.” Kenneth Patchen, Poet
|
|
|
|
|
I want to make Cyber café software in windows with C# platform.
I make one page(Pannel Window of Server) for showing many terminals here. That means I will see which one connect or not. So Main thing is how to create and how to link with terminals info in server.
I f u have any link related my notes . plz advice or mail me
ramkrishn98@gmail.com
Ram Krishn Mishra
|
|
|
|
|
You need to create a Server/Client system that will allow multiple terminals to connect. Google for "C# sockets" and you will find lots of information.
|
|
|
|
|
To add to what Richard said: Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
