I'm going to be playing with python for a while and I was wondering if there were any sites like this one for python(maybe even ruby). I've not been able to find any. I was also wondering about possibly supporting IronPython here since in a round about way its part of .NET -- modified at 16:19 Tuesday 22nd August, 2006

Thank you.

How do I Insert a copy of a record when I want to change ONLY one field.. INSERT INTO tb SELECT field1, field2, field3, field4, field5 FROM tb AS tb_1 WHERE (field1 = @Value) None of the selected items are the primary key, and this insert works fine for a perfect clone, but I need to be able to modify field1 with a textbox the user can type in. I know there is VALUE keyword.. but I can't seem to get it to work for just field1.

Sweet! I just found out I can flag the primary key as the identity column, now it works!!! Yay! Thanks alot for your help guys. -- modified at 15:04 Tuesday 25th July, 2006

If I use INSERT INTO tbABC SELECT (all but primary key) FROM tbABC WHERE Name = @Name I get an error back saying that the Column Name or number of supplied values does not match the table definition. If I use INSERT INTO tbABC SELECT * FROM tbABC WHERE Name = @Name I get a name saying that the primary key can't be duplicated (duh)... I've been looking all over the table design and properties in SQL and I can't find where I can actually pick an autonumber for the field type. I thought that inside my dataset I'd set to AutoIncriment, seed 1, step 1.. isn't this correctly setting autonumbering for an SQL database? I'm used to access just having autonum as a field type choice. Thanks.

I'm trying that, and I dont think I'm doing something right in the query. Is field1 supposed to be the primary key?(as per default)? I'm getting "primary key doesn't allow nulls" error, and my field1 is set to the autonum. By autonum, I mean that SQL is set for INT for primary key, and I've got my dataset flagged to incriment 1, seed 1. I think this is the correct way to set for autonum? I'm used to there being a default "autonum" from access for the field type... -- modified at 18:26 Monday 24th July, 2006

I'm literally trying to clone data rows, nothing very complicated, infact, they aren't even going to be changed during this section of the project. I've captured the rows I want to clone using a custom SQL query, but I'm not sure how to insert them back into the database with new ID's(primary key is autonumber)... can't I just run a .update of some sort? I've tried copying the data table from results of my query and merging into the complete table, that doesn't make any change. I dont seem to be able to .insert anything other then independant values for each column. I'm using VS 2005 and C#. Thanks.

I'm literally trying to clone data rows, nothing very complicated, infact, they aren't even going to be changed during this section of the project. I've captured the rows I want to clone using a custom SQL query, but I'm not sure how to insert them back into the database with new ID's(primary key is autonumber)... can't I just run a .update of some sort? I've tried copying the data table from results of my query and merging into the complete table, that doesn't make any change. I dont seem to be able to .insert anything other then independant values for each column. I'm using VS 2005 and C#. Thanks. -- modified at 17:09 Monday 24th July, 2006

Thanks! worked like a charm...

I've done a tbAdapter.fill(DataSet.datatable); How do I edit the datatable through code? I need to be able to add new rows to the table and I'm having trouble figuring out how. Anyone have a guide that demonstrates this though code? (IE, no interface for background processes). -- modified at 19:59 Thursday 29th June, 2006 I dont understand how to use dataSet.DataTable.addTableRow() if anyone cares to explain this to me (if it is what I'm even looking for). Thanks again.

stringVariable = dataGridView.CurrentRow.Cells[index].Value.toString(); That worked for my purposes just great! Thanks a bunch!

I'm trying to find a way to grab a given rows cell information, for now just the primary key, and store it in a variable to use somewhere else. If I use listbox's I can simply use .selectedValue() and it gives me exactly what I need, but in this case, I'm needing to do it with a datagridview and this attribute doesn't exist. Thanks!

I'm trying to find a way to grab a given rows cell information, for now just the primary key, and store it in a variable to use somewhere else. If I use listbox's I can simply use .selectedValue() and it gives me exactly what I need, but in this case, I'm needing to do it with a datagridview and this attribute doesn't exist. Thanks!

I'm sorry, its probably just me. It is the end of the quarter and this project was dumped in my lap as a last minute deal and it wasn't planned out other then some oddball requirements. As far as a book goes, I'm been waiting to get a book on ADO.net 2.0 (Pro ADO.NET 2.0 - Sahil Malik) but they wont budget anything else until next month when the new quarter kicks in. This is what happens when people find out a hardware engineer also has background in software development.

Don't suppose you know how to capture a single attribute from a row in a datagridview do you? -- modified at 19:57 Tuesday 27th June, 2006 I'm trying things like datagridview.rows.indexof(); but it says I must give it a variable, well, if I had the variable I wouldn't need it to tell me! =P

I think I've got a solution. It seems to work without problem. myBindingSource.Position = variable; -- modified at 19:11 Tuesday 27th June, 2006 My older post got answered in a rather rude way, thanks for not treating me like an idiot.

I found what I was looking for... there is a .position for the bindingsource and I was able to pass my variable to it and everything works now. Was that really going to be such a hard answer?

What I meant by using a parameter is if I search for "part A" when the new form opens, it only populates the datatable with part a being record 1/1. This doesn't help me when I'm trying to add a new record or delete the current record because the actual table row is n/###. I'd appreciate an answer reguardless of how complicated it is. I understand the basics of ADO.NET, but that doesn't help when a function I'm looking for doesn't exist by any means I'd think to look for it. Thats no better then asking someone to make a Caesar Salad dressing, and having them screw it up because they didn't know to include anchovy paste, its not their fault for not knowing what isn't there, but that also doesn't mean that they are clueless in cooking.

I found this article here[^] I've tried to follow because that sounds like my problem, so my code looks like this. this.tbAdapter.fill(dataSet.tb); this.dataSet.tb.select(); that still gives me record 1, instead of the one I want. What am I doing wrong? -- modified at 16:41 Tuesday 27th June, 2006

I'm trying to force a window to jump to a specific row in my database when I click a button. I'm using a "details" display of the table, and there is a binding navigator(supplied with the drag and drop creation of the form). An example would be (I'm using c# btw) [Parts list] 1. 2. 3. ... Select Part [2.] New Form with more details on part 2. Edit/Delete/New part I can use a modified SQL query to return just the one row, but then the add/delete/new buttons dont work because the mapping is lost to the original data. I can't imagine this is something hard to do, but I've been all over the net posting for an answer and nobody has even attempted. Any help is appreciated.