Posts by Vanderlei • 192 points
11 posts
-
2
votes1
answer1403
viewsA: Decimal values being rounded in Sqlite
I have found a solution based on the suggestions of colleagues. The monetary value fields were created as INTEGER and I treated the entire decimal formatting via code in the application. The class…
-
3
votes1
answer1403
viewsQ: Decimal values being rounded in Sqlite
After migrating my database from Access to Sqlite 3 in a Windows Forms application, I have been having difficulties with Decimal values. If I run a simple select: SELECT * FROM Item WHERE id = 1;…
-
3
votes1
answer934
viewsQ: Modify String object value passed as parameter
I need to change the value of a variable dynamically by passing it as a parameter by an auxiliary method. I have always used the values of the parameters by moving from right to left. It is possible…
-
0
votes1
answer72
viewsQ: Integrity breach not released in BD Sqlite
CRUD in C# is not throwing integrity breach error while deleting BD Sqlite dependent record. query = "DELETE FROM "+ table + " WHERE id = '" + id + "';"; int returnValue = 0; try { conn = new…
-
3
votes1
answer643
viewsA: Format Textbox for thousands?
Friend, I discovered that if you divide the "value" by 1000, it results in the format with 3 zeros before the comma as you want. Modifies this line: valor = Convert.ToDecimal(txt); at this value:…
-
1
votes0
answers85
viewsQ: Get primary key values in Table Adapter
How can I get all primary key values in one Table Adapter. One by one I can get at the time of the Insert with this code: PegaIdOrc = orcTableAdapter.GetDataByMaxIDOrc().…
-
0
votes1
answer435
viewsA: Block alphabetical sorting in Datagridview
Studying the SQL language, I discovered that I can create a "temporary" or "virtual" column and also show the values already calculated without having to do this by Datagridview. I simply created a…
-
0
votes1
answer435
viewsQ: Block alphabetical sorting in Datagridview
My Datagridview receives product data from a database. They are: description, unit price and quantity. I programmatically added a subtotal column and added the * quantity unit price calculation. As…
-
3
votes1
answer363
views -
1
votes1
answer1137
viewsQ: Update in Visual Studio database
could tell me where is the error in this small piece of code that I am creating for a budget program with a database with 4 tables (only the last cmd7 object is not accepted in the compilation):…
-
1
votes1
answer408
viewsQ: Insert to foreign SQL keys
I am learning a programming language and I set out to develop a budget program. My first obstacle is to add the values of the primary keys in the foreign keys of the respective tables. This code…