Thank You! After some trial and error with syntax and the imported column names from excel it worked as advertised. You saved me a ton of time. Jeff

Thanks for the response. That sounds simple enough, except that I don't know how to access each of the data rows when none are selected. All of the literature that I am looking at assumes that data in the datagridview was taken out of a database table and then updating is a snap. but... it seems strange to me that using a datagridview for data entry should be so hard. (I think I am overlooking something, but I don't know what it could be.) Unfortunately, I am very confused and don't really know where to proceed from here. Jeff

Hello all, I am a bit perplexed and maybe one of you can point me in the right direction. I have a windows form containing a DataGridView that has data imported into it from Excel and a combobox representing a job number. A user will make changes to the data in the DataGridView and then I want to post this entire DataGridView plus the job number to a MySQL table. I havne't found any information about how to post the unbound DataGridView to the MySQL table with one extra column of data (job number). What I would like to know is the proper steps to accomplish this task. I am using VS2008 and the MySQL Connector/NET v6.2.3 Thanks Jeff

If I understand correctly, below is the code from the frmMain.designer.cs file. I am a bit confused over this whole thing as to what does what and why. If you have a good reference resource that might help me I would appreciate it, so that I don't use too much of your time. I have Murach's C#2008 and SQL Server 2008 for Developers as well as a number of older MS Press books for C#. The MSPress books are all quite dated and a bit sparse for database information. <pre>// // tasksBindingSource // this.tasksBindingSource.DataMember = "Tasks"; this.tasksBindingSource.DataSource = this.timeSheetDataSet; ... ... ... // // tasksDataGridView // this.tasksDataGridView.AutoGenerateColumns = false; this.tasksDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.tasksDataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.dataGridViewTextBoxColumn1, this.dataGridViewTextBoxColumn2, this.dataGridViewTextBoxColumn3}); this.tasksDataGridView.DataSource = this.tasksBindingSource; this.tasksDataGridView.Location = new System.Drawing.Point(36, 195); this.tasksDataGridView.Name = "tasksDataGridView"; ... ...</pre> Thanks for the time and the help. Jeff

Thanks for the advice, but... I am not sure how to implement your samples. I am using the "built in" features that generate the code automatically and it looks like the lines you suggest are being called... except for the DataBind() function. it doesn't appear to be an option for this grid control. :( Thanks again for the help Jeff

I have been struggling for a long while now trying to get a simple table to display in a data grid view on a C# windows form.   I believe I am doing something wrong but...I can't see where I am straying. All of the examples and sample files essentially tell me to create a new data source and then drag the table I want to use onto the forms designer and wa-la! :confused: but it isn't working for me. I can preview the data in the table and I see the records there, but running the form shows a blank grid and a -1 shows when I click in the grid. Can anyone lend some advice? I am using VS2008 SP1 and Access 2007 on a Windows7 machine. I also tried with the exact same results SQLExpress 2008. Jeff

Mike is right. DRM only works for downloaded purchased music and copying downloaded purchased music to other computers. (Lime Wire and other Napster clones are not counted) It is annoying and the reason I just can't buy downloaded music. I have bought a few, had my computer crash shortly after and then lost them. I think I prefer to rent them via, rhapsody. I know it sounds stupid ,but if you looked at my CD collection you would see that there are gaps of years (ok decades) between purchases and I have recently realized that I don't EVER listen to them again after a few months. (exception taken to Pink Floyd, Police and Madonna <-early years.) Renting them lets me have everything I can possibly imagine until I get bored with them and find a different hobby for awhile. Recently, the last year, I have taken up running and have started listening to music again and my old collection... sucks. Renting lets me have all the new stuff I like to run to, Thalia, Nelly Furtado, Beyonce' and on and on :)

How about adding a version field for the VS.Net version that the article was written in. I don't get to spend much time here anymore and my version of Visual Studio is beginning to become dated. with no plans to update it soon. Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

Nope not just you. Mine haven't changed since I first was able to log in today. But the membership numbers still keep climbing :) Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

I have been deluged with spam lately as I am sure all of you have also. Most of this spam isn’t even intelligible. Look here[^] for the latest US Congressional Bill to get passed. GWB is expected to sign this bill when it gets to his desk. How can it be profitable to send millions of people the same dozen emails that can’t even be understood? I just don’t see the logic behind this. Can anyone enlighten me? Will this law really lighten the load? How can the US enforce spam from other contries? Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

Good Advice there. Doesn't sound like you harmed any linux penquins with that sage advice. BTW doesn't say much for NTFS security when anybody can access all of NTFS files with out regard to security or user permissions. I wonder if longhorn will or could fix this? Actually I hope that it can't. I kind of like know a simple little secret about recovering my files with a bootable CD Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

Marc Clifton wrote: I see RSS as a cocktail party thing. That's what I think about blogs. Sorry but I couldn't resist;P Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

RSS is kind of nice with outlook today. I can get the local weather, latest computer and financial news all with out firing up my browser. And as a bonus the company that I work for doesn't allow third part feeds like the weather bug so I get all of the bennifits without having to argue with IT. Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

Thanks now it makes sense Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

Would that be the test similar to the one required to procreate? :-D Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

I have seen reference to this from time to time but I don't get the joke. Could you explain? Is a CListCtrl hard to code? Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

I've been thinking about moving to Mexico and getting a job or maybe I could open an American food restraunt in China? :rolleyes: :-D Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

It's too bad that it really doesn't work that way. The workers are the first to get wacked and the managers are the last. Even when the company is SOOO Top heavy that everyone sees it. But big companies have a good-ole-boy network going on and they don't want to upset thier lunch budies when times get rough. The parent company I work for hasn't had a decent order in 3 years. They have lived off of us because we were the only profitable portion of the company. (Part of the reason is lower overhead and cheaper wages) But two weeks before christmas they finally started waking managers but that was after 70% of the real work force was eliminated. This does make some sense in a way because you need a management structure in place to hire new (cheaper) labor when the orders start coming in. But IMHO it really is no way to run a business especially a Fortune 1000 comapny. Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

The amount of chinese that I know will just keep me alive. My wife was born, raised, and educated in Tainjin China. It is a small town about 10 Million people 1.5 hours south east of Beijing. She is the expert and when I didn't recognize the phrase I asked her. Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]

I am a big fan of the Sharp Zaurus check here. I have the SL-5500 it has a built in keyborad and and has accessories for a camera and a wire or wireless ethernet connection what ever you like. The monitor thing though I think is a lost cause. Sony makes a cool little notebook about 11" x 8.5" folded here Jeff Patterson Programmers speak in Code. http://www.anti-dmca.org[^]