Last post Oct 16, 2013 08:33 AM by earlcools
Oct 14, 2013 12:04 PM|earlcools|LINK
I have a table with some columns: Name, District,Score, SchoolAssigned the names, district and Score already
has data however I am must use the score to decide which school they get assign too.
I know that I must used If score is hight enough but I still trying to see how to update a table the SchoolAssigned column.
This is what I have so far
i = 0; i <= (this.dataGridView1.Rows.Count
- 1); i++)
Query = "insert
into Student$([School Assigned])values('test')";
I know this is wrong can anyone help?
Oct 14, 2013 12:07 PM|Rajat|LINK
I think you want to update the
so use update command like
UPDATE Student SET [School Assigned] = 'SchoolName' WHERE Name ='StudentName'
Oct 16, 2013 08:33 AM|earlcools|LINK
this work inside SLQ not in visual studios