EFileTahi-A

Yeah, I agree with you unless the person who's making this backcolor changes knows what he/her is doing... Fortunately am applying a pre-defined systemColors "Control" color to the DateTime control backcolor to make it look like "disable" under certain conditions, overriding thus, all possible problems you described above... Yet, I have functions that check all pre-defined colors in order to counter (again) the issues you have described in case I use my own colors... PS: What you have said was nothing new to me but tks anyway... http://img.photobucket.com/albums/v698/EFileTahi-A/EFile_Torpedo.jpg

Honestly, I never knew anyone who would be upset for having some software with controls that would not be in its predefined color, unless we are talking color combinations like "hot red" windows, "yeallow" text and "shock-pink" text-boxes. Also, it's normal to have customized skins and interfaces in nowadays that's why almost every control in .NET have the option of changing the background, foreground (...) colors. A person having a problem with the backcolor of some DateTimePicker background in some program will easly hate even more programs with customized skins IMHO... A person with problems to say the least... People want programs that perform their job well, free of bugs, that's what sells at my company. Never had the suggestion from any client saying: "I like your software, but I would prefer the text boxes in white" or "Is it possible to change the backcolor of the program controls?"... The reason you did not liked my "counter-question" was the same reason I did not liked yours, as I think it was truly useless. If I want to change the controls pre-defined "white" color its because the same "white" color does not fits my needs, so why suggesting the same old color you knew I was refusing from the beggining? Because windows loves to have controls white? Because you would not change its color? Luckly, I do like to be original and creative...

Ok, thanks for ur posts... what is wrong wanting to change the controls back color?

... a dateTimePicker object? It's always white and I can only change the colors of the board that opens once I press it... Grrrrr

I discovered the method... "SELECT * FROM tablename Limit x,y" :D - THREAD RESOLVED -

Imagine that I have a table with 100 records and that I need to select all records from position 20 to 50... How? Thank you...

Oh my God! so simple...! Thank you both :) - THREAD RESOLVED -

Am trying to select only one row from a specific table, the problem is that I just can't make it work. I tryed the following: SELECT TOP 1 * FROM tablename SELECT TOP (1)* FROM tablename SELECT TOP 1 FROM tablename SELECT TOP (1) FROM tablename But it always end up with: An unhandled exception of type 'Microsoft.Data.Odbc.OdbcException' occurred in system.data.dll Additional information: System error. When I try to fill an DataTable... public System.Data.DataTable InDocLin(int iHowMany) { if (iHowMany == 0){sSQL = "SELECT * FROM InDocLin";} else {sSQL = "SELECT TOP (" + iHowMany + ") * FROM InDocLin";} OdbcDataAdapter daTemp = new OdbcDataAdapter(sSQL, MyConnData); System.Data.DataTable dtTemp = new System.Data.DataTable(); daTemp.Fill(dtTemp); return dtTemp; } SELECT * FROM tablename <--- this works fine, so the connection and table are ok...

As always, if I did not got explicit enough let me know about it...

Hi to all... How can I sum numeric fields per page? That is, the sum will be reset for every page. Yet, how can I then show the sum of all the sums done in every page on the last page?, And making it show some new visual like with some lines textboxes etc..? page1: ------------------------- col1 col2 col3 100 50 10 100 50 20 100 50 10 50 100 10 350 250 50 Total ------------------------- page2: ------------------------- col1 col2 col3 100 50 10 100 50 20 100 100 20 100 100 10 400 300 60 Total ------------------------- page3: (Last page, with modified visual) ------------------------- col1 col2 col3 100 100 10 50 50 20 100 50 10 50 100 0 ******************* 1100 850 140 Total of all pages (including page 3) ******************* I know how to perform sums... but only for total pages...

Better late then never, thks pendragon... :)

Thank you very much! Also, I do I create a windows menu when I click it?

How can I add my program to system try, you know, near the windows clock :)

How can I run my software after its instalation is finished?

I would like to kown how can config CrystalReports to print in A5 format so that ITextFields will only fill half A4 paper size and print the remaining ones on another page. Hope to hear from you soon!

- THREAD RESOLVED -

Althought this thread issue was not resolved or received any further support for too long I will now declare that it is no longer active since I moved to mySQL and there is not the "null values" problem thing... - THREAD CLOSED -

Linking a filtered datatable to the Crystal Report fulfilled all my needs... Thank you once more. By the way, I hope you can have internet soon at your home :) Cheers! - THREAD CLOSED -

Ahhhh, yes, you're right, it works fine without the AcceptChanges :) Thanks to all who post here... - THREAD CLOSED -

Am begining to desperate... I just can't make this code save the records on mySQL database... I wonder what am I doing wrong... DataTable dtInDocLin = new DataTable(); DataRow newRow; string sRecBefore = ""; string sRecNow = ""; sSQL = "SELECT * FROM InDocLin"; OdbcDataAdapter daInDocLin = new OdbcDataAdapter(sSQL, MyConnection); daInDocLin.Fill(dtInDocLin); OdbcCommandBuilder cbInDocLin = new OdbcCommandBuilder(daInDocLin); //dtDocLinTemp is a declared as static datatable in the declaration form's section dtDocLinTemp = dtInDocLin.Clone(); //adding a new row into the static datatable newRow = dtDocLinTemp.NewRow(); newRow["numlin"] = 30; newRow["numdoc"] = 10; dtDocLinTemp.Rows.Add(newRow); //I don't know if acceptchanges is really necessary dtDocLinTemp.AcceptChanges(); //this actualy counts the correct rows inside dtDocLinTemp which is "1" sRecBefore = dtDocLinTemp.Rows.Count.ToString(); foreach(DataRow row in dtDocLinTemp.Rows) { dtInDocLin.ImportRow(row); } daInDocLin.Update(dtInDocLin); dtInDocLin.AcceptChanges(); //This also returns the correct number of rows which is "1" sRecNow = dtInDocLin.Rows.Count.ToString(); This code works with no prob, only, dtInDocLin does not saves the new row into the mysql database...

I realy can't tell, What I do know, is that it works prefectely in VB6! :confused: :confused: :confused:

dtInDocLin is the table that will recieve the new rows from dtInDocTemp, that will also send the changes to the mySQL Data Base. Sorry I was not explicit about this... And yes, this was a typo :) Anyway, by the time you made post I actualy saw the "import" thing you mentioned (twice) and I managed to do it... unfortunately the dtInDocLin which got the new rows from dtDocLinTemp for some good reason are not recorded into the database after doing dtInDocLin.Update() Am Trying to fix this up, If I get trouble about it I will post... Thank you for you help Nerseus! Truly apreciated!

Well, notice this: I have declared a Static DataTable on DB_Engine class, which have to following code: //Query to execute in order to load the DataTable sSQL = "SELECT * FROM InDocLin"; //Here I create a temporarely DataTable to store all Data from InDocLin table OdbcDataAdapter daTemp = new OdbcDataAdapter(sSQL, MyConnData); //Now I Fill the dtTemp with all the InDocLin data System.Data.DataTable dtTemp = new System.Data.DataTable(); daTemp.Fill(dtTemp); //I clone all the info from dtTemp to the Static DataTable (dtDocLinTemp) dtDocLinTemp = dtTemp.Clone(); //Clearing any existing rows dtDocLinTemp.Rows.Clear(); I think I have now my static DataTable ready to recieve new rows with the InDocLin table shema right? Ok, now during run time, this static var dtDocLinTemp will suffer changes, that is, rows will be added. So, when it reachs the copy part, I will need to retrieve all the added rows from dtDocLinTemp to the DocLinTemp mysql table. I did this code to acomplish this: // here is dtInDocLin Table that will recieve the new rows from the static Datatable DocLinTemp //I did this to get the rows from the static table DataRow[] rows = DB_Engine.dtDocLinTemp.Select(); //So now I supposely just need to put them back on dtInDocLin dtInDocLin.Rows.Add(rows); Unfortunatelly it give me this error when executinr the dtInDocLin.Rows.Add(rows); line: I have no ideia how to see the values within rows, I mean, in a datatable I do datatable.rows[rownumber][colname] but with rows I haven't figure out yet... I can't tell what am I seding in number column back to dtInDocLin... Am not experience with C# database related objects. Hell! Am not experience in Oriented Objects languages all at! So, please, be patience with me...

Hi nerseus... They were in diferent Access data bases with independent connenctions. That is DocLinTemp and InDocLin were from diferent Access Data Bases I mean "were" because I am converting the program to mySQL, and I am no longer using the DataTemp database which was holding the DocLinTemp table, instead, I will use an DataTable image of InDocLin in memory (that explains the other thread of mine about copying rows between tables) instead of storing it on an independent DataBase... This was the way the software am currently working on was done in VB6, and am converting it to C# and things can go diferent now...

Ok buddy, I will post again as soon as I have time to code that :) Thank you pendragon.