|
This doesn't help me much... I have multiple sheets in the document and after I see that a certain sheet is present I have to process it:
var command = new OleDbCommand(string.Format("select * from [{0}]", sheetName), connection);
var adapter = new OleDbDataAdapter {SelectCommand = command};
var ds = new DataSet();
adapter.Fill(ds);
connection.Close();
DataTable dt = ds.Tables[0];
foreach (object dr in dt.Rows) {
string[] array = Array.ConvertAll(((DataRow)dr).ItemArray, new Converter<object,>(Convert.ToString));
// continue processing here...
}
So I would still have problems in the case of a sheet name that contains a dot and a space as mentioned in my initial post.
Is there any workaround for this issue?
Thank you!
|
|
|
|
|
Hi everybody
How can i define a variable that i can use it in two different forms.
for example
i want to define a variable like
string word = "Hi";
then i can write this code in a button in the second form
MessageBox.Show(word);
Thanks everybody
Hi everybody
How can I define a variable that I can use in two different forms?
For example
I want to define a variable like
string word = "Hi";
Then I can write this code in a button in the second form
MessageBox.Show(word);
Thanks everybody
|
|
|
|
|
You can create a class and define this variable as constant.
public class Messages
{
public const string Word = "Hi";
}use it like
MessageBox.Show(Messages.Word);
|
|
|
|
|
But what if I don't need the variable as a constant
For example I have a Textbox on Form1 and its name is TextBox1, and I want it like that
string word = TextBox1.Text;
Then I can show this text stored in the variable (word) in a Message Box in the second form.
Thank you so much 
|
|
|
|
|
|
Create a static class and put your string variable as a static variable in this class.
This will allow you to share value of string variable between different forms.
-Dave.
------------------------------------
http://www.componentone.com
------------------------------------
|
|
|
|
|
(IMO) That's bad design man. Better is to have properties (or get/set methods as some don't like properties)
|
|
|
|
|
Hello Everybody! I'm making a program which can read RSS file on the internet.I want to display the content of tag title such as [ &quot;Hello&quot; ] on the ListView , but the ListView only displays ["Hello"] . How to make it display [“Hello”]? Using a replace method to replace &quot; to " in the content of tag title or existing another method ? Thanks for reading!
modified on Thursday, July 17, 2008 3:01 AM
modified on Thursday, July 17, 2008 3:02 AM
|
|
|
|
|
You'll need to set the ListView control's font to one that supports open and close quotes and replace the "es with these characters.
/ravi
|
|
|
|
|
Oh I forgot to check "Ignore HTML tags in this message (good for code snippets)" for above post.
@Ravi Bhavnani: I tried to change ListView control's font but the problem wasn't solved.
modified on Thursday, July 17, 2008 3:31 AM
|
|
|
|
|
Hi all,
I am working on a application that is using WCF service. and on backend it has DB2
so when ever i am trying to retrive the records more then 1200 it fails...
i have set readerQuotas maxArrayLength="5000000" but still am getting timeout error when trying to retrive more 1100-1200 records
please suggest me here .. how can i retrive all records in one go .. without changing the time out setting from DB2
..
Thanks
Vikas
vikas da
|
|
|
|
|
One more thing i forgate to tell that i am displaying the records to the grid...so before displaying the records so while reading the records i kept a condtion there like
if(i==1800)
{
break;// a breakpoint is there
}
its reaching to the break point but not able to disply ...
please help me here
vikas da
|
|
|
|
|
Hi,
i am using a tool freely available on net called as IMacros.
It's a plugin which gets available as a toolbutton upon installation.
I want to create such application.
So i would be glad if anyone can provide me with how that can be achievable.
Thanx in advance
|
|
|
|
|
Please read this
http://www.codeproject.com/KB/security/encryption_decryption.aspx
What should I pass to the public methods as Source and Key.
I am just trying to encrypt the password
please let me know
Happy Programming!
Regards,
ctrlnick !
|
|
|
|
|
Why not post your question in response to that article? Then the author can help you out directly.
Life, family, faith: Give me a visit.
From my latest post: "We are Christian, resistance is futile. Your Jewish traits will be assimilated into the Church collective."
Judah Himango
|
|
|
|
|
What is the best object in C# to create a board game (like chess, colonization, civilization)?
Datagridview? (i only use it to get sql data)
Panel?
400 PictureBoxes? 
|
|
|
|
|
Use a 2d drawing API and do the board yourself in those constructs. I'd recommend Microsoft's XNA framework.
Life, family, faith: Give me a visit.
From my latest post: "We are Christian, resistance is futile. Your Jewish traits will be assimilated into the Church collective."
Judah Himango
|
|
|
|
|
I use a big bunch of buttons... kinda like MineSweeper. But only when appropriate; chess or checkers could be done that way.
|
|
|
|
|
Hello, All!
How can I get standart Windows XP Time Zone map? Is it COM-object? How can I use it? Or I must implement it custom?
Thanks, for help...
|
|
|
|
|
Hi all,
I do have lots of dlls saved in one folder and the new dll will be added to the same folder frequetly.
I also have a program, myProgram, that needs to reference all dlls in that folder.
Inorder to use the functions/methods of a dll, we have to
1) add Reference to myProgram,
2) using mydll;
3) create the instance and call the appropriate function.
So how can I add the reference and import the dlls as the program click on Button so I can use functions from those dlls.
or is there any other ways that myProgram to find out if there is new dll in the folder and start using it without recompliing myProgram.
|
|
|
|
|
Hi,
if your source code is referring to managed code that resides in some DLL, then you need to add
a reference, and you may choose to (or not to) use a using statement, in order to tell the compiler
how to find the types you are using.
if on the other hand you want to use types from some DLL files using reflection only, then no
reference and no using statement is needed pointing to these DLL files; with the right code
you can discover and use any managed DLL you can reach. Look for "reflection" on CodeProject or Google.
|
|
|
|
|
|
Yes, as when using add-ins. I've done a few.
1 + 2) Those concepts don't apply to runtime, only to development and compile time.
Your app can browse the directory for DLLs, load the assemblies they contain, and it can then instantiate and use the classes therein.
But it has to know what sorts of things it can do with the classes.
For doing add-ins, I define an Interface (or abstract class) that the app knows about.
After the app loads the assembly it browses the classes contained and instantiates any it finds that implement the Interface.
See System.Reflection.Assembly
|
|
|
|
|
Hi,
I spent a bit of time yesterday debugging a previously working app and eventually traced my problem down to the default handling of command line arguments.
So, assume a console app using the standard Main method of
static int Main(string[] args).
If I format a command line argument as say
"\DataFiles"
then I get the expected args[0] of \DataFiles which has had the quotation marks stripped off.
If I pass \ then I get args[0] of \ , again as expected.
However if my command line is quoted and has a final backslash then it all goes a bit wrong.
So "\DataFiles\" turns up in args[0] as \DataFiles" from which it appears that the \ is being interpreted as an escape character.
Just for a bit of fun I passed in the command line argument "\"\"" to confirm the hypothesis and got "" in args[0] as predicted.
I know there are plenty of command line parser classes which will do the job properly but can anyone explain the rules for the inbuilt parsing as I can't find any reference to the rather odd action that I have found.
Alan.
|
|
|
|
|
Alan N wrote: "\DataFiles\" turns up in args[0] as \DataFiles"
Hi,
\" is the way to include a double quote inside a string literal in C/C++/Jave/C#
If you intend for "\DataFiles\" to be a C# literal, then it fails twice:
the \D is an invalid escape sequence,
and the string literal is not closed on the line, since the \" is a valid escape sequence which
translates to a double quote (and hence does not terminate the literal)
BTW: don't get fooled by some debugger output in Visual Studio, they are known to mangle the quotes
a bit.
Hope this helps.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
