Search results for query: *

I'm sorry... I am trying to use my brain. I'm just unfamilar with all the dot stuff. Notepad shows "001" and Excel shows 1. I've done some research on csv files and leading zeros is in fact a known problem when viewing them in Excel. This is what I have learned... "Excel will always...

Well, again you have taught me well. I understand and it works! You wouldn't believe what my little program does now!! I'm so excited. It's almost done and ready for some testing, but there is just one final little thing that I don't understand how to fix. In my database I have EmpNum as a...

Yes, I did mean datatable its just the dataset I use contains only 1 table. I promise to get my terminology right next time. :) The following code is what I am using to write the .csv file. My datatable does not contain any commas or double quotes so I haven't tested against that. Dim...

Nevermind post above. I created a CSV file from the dataset with info I gathered online! Works like a charm!!! I'm loving this again!!! :)

You have amazed me once again! With a little fanigaling, your SQL works perfectly. I sure hope you are making the big bucks somewhere because you obviously know your stuff! I just need to do one more big task and that is make the CSV file. Is it best to drop the dataset into a grid and...

Ok cjard, I knew I could count on you as this works like a charm! Now I have just one more question about this crazy program. My company's pay periods is for 2 weeks. For each week if a person works over 40 hours, they get overtime for anything over 40 hours. So, what I have done is run the...

cjard, You offered a great deal of help previously, but I am having trouble with a SQL statement similar to what you posted. Can you tell me what is wrong with it? The problem is with the CASE statements. I've taken 1 out and it still doesn't work. I get the error "Error Info.GetDescription...

I have added and populated a datagrid adding a dataadapter to the form and making the connection and creating the dataset etc. When the form loads, the datagrid generates properly, and I can edit a field by clicking the field in the datagrid and type it in and I can add a new row by clicking...

Thanks cjard! You are the best! I appreciate your offer so much. However, I almost have this project done now and I must admit, I'm pretty proud of it, although I know that the code is ancient. But if it works, that is all that really matters, right? I didn't know about the aggregate...

Thank you cjard and vis781. First of all, I discovered the problem with the sql statement. I needed an aggregate function to make it work. modbcmdSelect.CommandText = "SELECT EmpNu, SUM((OutDate-Indate)*24) As HoursOnTask, Purpose From Hours Worked etc. Now this works like a charm...

I'm sorry, I am not able to open your project. It says you have created in a newer version and cannot open it. I am using MS Visual Studio .NET 2003. I think I am going to go into a corner and sulk...... I just don't understand why that SELECT statement will not work. It is such a simple...

Well, so much for hardship.... I'm having it again! I have this 4" thick book on vb.net and ADO.NET and I am finally starting to understand the blasted thing, thanks to you cjard. However, I'm having a prob with the sql statment retrieving a date field. The SELECT stmt works fine if I pull the...

Holy Cow!!!!!!!!!!!!! :) Incredible!!!! You make this seem soooooo easy! Why couldn't I see it this way. It makes so much sense! I'm embarassed as I know you were rolling your eyes at my ridiculous code!!!! I am going to bag my old application and start over doing it your way. If all...

First off.. thanks are again in order. Again I truly appreciate your time and expertise. Secondly, I may have jumped into a project that is a bit over my head and have realized that I do not have a grasp on database programming as I once thought I had. I’ve worked with mySQL in web...

cjard... I'm loving this! There is nothing more that I want in life than to master this!!! I would love to learn about the designer but I think learning the hard way first will make me appreciate the designer and how it works. Thanks so much for making this clear to me! You wrote, That makes...

Ok.. great point cjard. Please excuse my ignorance... just learning this. I must add that this is the greatest learning experience ever! So after setting the adapter with the SELECT stmt you suggested, I would use this code then to update???? Dim foundRows() As Data.DataRow foundRows =...

Thanks for clearing this up for me. Everything works like a charm. I appreciate all the help.

I am trying to pull values from a specific row with a select stmt in a database so I can set some variables. However, my code is not grabbing the value and I am getting the error "Index was outside the bounds of the array". I am not sure what is wrong. conn = New...

I am trying to create somewhat of a time clock program. When the user punches in, I need the current time to round to the nearest 15 minute interval. For example, if a user punches in at 6:50 am, it needs to write to the database 7:00 am. If a user punches in at 8:05, it needs to read 8:15...

vis781, works like a charm now. It is so easy to understand once I see how it is done correctly. I guess I just don't completly understand datarows and datases and all the choices that come with each. I just need to work with databases more. Thank you once again for setting me straight!