Thank you:-D

Hello, May I know how I can create a 2 dimension textbox array? I know how to create a 1 dimension textbox array, but I am having trouble trying the 2D. Thank you!!

When I try: INSERT INTO Product (ID, name, date) VALUES (123, NULL, NULL) It works fine when I use NULL to 'name' and 'date' in the INSERT statement. However, when I use a variable: INSERT INTO Product (ID, name, date) VALUES (123, @myName, NULL) And assign @myName.Value = null to the variable, I get an error message when I execute this statement. (For example: myInsert.Parameters["@myName"].Value = null;) My question is: If I use @myName in the INSERT statement, how I can assign NULL to it?? Thank you!!:)

I have a question about using ExecutiveNonQuery() in C# (using Access). The following code would return 0, when I specify "@myMax".Value = 1 (see below). However, if I changed @myMax to a constant (ie. not using a variable), everything worked fine and it returned 1 as the result. The problem is that since it doesn't throw an exception, and only returns 0, I have no idea what's wrong with the "Update" SQL statement. Thank you and appreciate any feedbacks!! // Updates the MAX, and NOTE field of a particular record OleDbCommand myUpdate = new OleDbCommand("UPDATE Product SET **Prod_max = @myMax**, Prod_desc = @myNote WHERE Prod_id = @myID", oleDbConnection1); myUpdate.Parameters.Add("@myNotes", OleDbType.LongVarWChar); myUpdate.Parameters.Add("@myID", OleDbType.VarChar); myUpdate.Parameters.Add("@myMax", OleDbType.SmallInt); myUpdate.Parameters["@myNotes"].Value = Notestxtbox.Text.ToString(); myUpdate.Parameters["@myID"].Value = ProdIDtxtbox.Text.ToString(); **myUpdate.Parameters["@myMax"].Value = 1;** try { textBox1.Text = myUpdate.ExecuteNonQuery().ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK,MessageBoxIcon.Exclamation); }

Oh, I solved the total page number problem too. Great!

Thanks! That page number problem is solved. I am now trying to get the total number of pages.

Thanks all!!

Ooh, I fount out that static declaration!! And, I solved that page number problem that I posted some time earlier!! Finally~!

Hi, may I know how I can declare a static variable in a simple application? I know that in C/C++, static int x can be used. How about in C#? Thanks.

Hello, I posted a similar msg earlier and I am writing a print command in an application. All it does, is to print out a document with some headers and footers. So, I used a simple way to printout headers and footers. However, I still cannot keep track of the page numbers when I print out a document. I looked up the properties of printdocument, pagesetupdialog and printpreviewdialog, but I couldn't find any 'related' property. I also tried to keep track of page numbers in my print function (a loop to Graphics.DataString(...), but failed. Can anyone please give me some ideas? Thanks so much!!

I am writing a print option in a project, and the coding of printpreviewdialog, pagesetupdialog, etc are done. However, I don't know how I can get the current and total page number. Can someone please give me some ideas? (I tried '%p', but it doesn't seem right.) Also, the printout needs to add certain headers and footers automatically (but not from user input). Can someone please give me a clue how I can get started? It's like the URL, date, etc on a printout from a web browser, but my project is not web application. Thanks so much for any help!

It's me again!:(( May I know how I can change the size of the console window using VC++ 6.0? I understand I can change it manually at the console window, but is it possible to do such coding? Thank you!:-D

Thanks so much! I will take a look at that! :cool:

Yeah, that's true. The extension can be changed. So, I guess I will have to write a function to check that, assuming the file extensions are correct. I am using the attrib member of the _finddata_t structure. It turns out that a folder is 16 whereas a .txt is 32 or 33. Can you please tell me what those numbers represent?! Thanks.

I posted a question earlier asking how I can read all files in an user specified directory. Thanks for all the answers. However, I'm wondering if it's possible to read or check the file type (eg. .txt, .doc, or a folder) as well?? Thanks for any help.:)

Thanks. But CFileFind doesn't work in my case. I am only writing a console app, not MFC. (Or may be CFileFind can apply, but I don't know how.) :)

Wow~! Thanks so much, guys! Joel Holdsworth wrote: _chdir( --dirname-- ); May I know what _chdir is? or what it means? Is it part of the fileinfo structure? Because I got an error msg for this. thanks again.:-D

Hi, I am using VC++ 6.0 to write a Win32 console app. Does anyone know how I can read all the file names in a directory if user specifies the directory for input file(s)? Thanks a lot!

I would like to use JTC.h in VC++ 7.0. Can I use that? if yes, please tell me how. I mean how I can link that to my project. thanks!

I got it! Thank you very much!:laugh: