Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Store checkbox to Database Yes/No Field
I also tried this: row["BOL_Jump"] = 1; But my try.. catch... block gets the same error and data is not stored. [...] row["BOL_Jump"] = 1; row.EndEdit(); try { dataAdapter.Update(ds, "tbl_Root_Characters"); ds.AcceptChanges(); } catch( Exception ex...- garak76
- Post #3
- Forum: C# (C sharp): Microsoft
-
Store checkbox to Database Yes/No Field
Hi, I receive an error when I try to store a checkbox value to my MS-SQL Database Yes/No Field. I assign the field with the following code: row["INT_Height"] = txtHeight.Text; row["BOL_Jump"] = chkJump.Checked; ... dataAdapter.Update(ds, "tbl_Root_Characters")...- garak76
- Thread
- Replies: 3
- Forum: C# (C sharp): Microsoft
-
Get MS Access table realtion info
Hi there, in my project I read out tables of a MS ACCESS database via ADO in Visual C++ .NET. I don’t know how I could get info about tablerelations - the information that one field is linked to another table. e.g. I want to have the information, that the field ROOMS.ROOMTYPE is linked to...- garak76
- Thread
- Replies: 0
- Forum: Microsoft: Visual C++
-
SELECT Statement
Yes I know its no longer available, but isnt there a possibility with cascading SELECT statements like I mentioned in the end of my question ??? If there no way, how do I work with temporary tables, do you know a good docu ? -
SELECT Statement
Hi everybody, I got a problem with mysql 3.23.56 with windows xp. I wrote this SQL Statement and it worked fine: "SELECT COUNT(*) as SchubAnzInGr, Round((TO_DAYS(NOW()) - TO_DAYS(SichereDiagnose)) / 365) as ErkDauer FROM Diagnostik, Schuebe WHERE Diagnostik.MitgliedsNr =...
