16,020,714 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Visual Basic questions
View Javascript questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by LSB71 (Top 14 by date)
LSB71
16-Mar-22 5:19am
View
If necessary, I could work in CRUD with C# from three tables (Type, Size and Price) but how to send the sums obtained in the file (ShoppingCart.cs)… ?
LSB71
16-Mar-22 3:59am
View
This is what I tried to do with my tables but without success... That's why sending a price once established would be easier...
See below :
LSB71
10-Apr-20 2:01am
View
Thank you very much, excellent I learn it every day
LSB71
1-Apr-20 9:34am
View
Hello Richard,
query_ttle "SELECT count(*) FROM sqlite_master WHERE type='table' AND name='My_Tble' COLLATE NOCASE" string
cmd {System.Data.SQLite.SQLiteCommand} System.Data.SQLite.SQLiteCommand
i 0 int
Whether the table is present or not, i = 0 !!!
LSB71
12-Mar-20 12:10pm
View
Deleted
I am facing a problem, whatever the solution I always have the same error message ....
LSB71
10-Mar-20 15:48pm
View
Thank you so much,
I will work on the subject and improve my code ... thank you all.
LSB71
10-Mar-20 13:24pm
View
How should I store them in my Sqlite database?
LSB71
8-Mar-20 14:34pm
View
Hello,
Thank you,
Indeed it works in the yyyy-MM-dd format and not in the dd / MM / yyyy format.
So with the code below it works ...
and I modify in Datagriview like this:
Datagridview1.Columns [1] .DefaultCellStyle.Format = "dd / MM / yyyy";
and it's great!
Hide Copy Code
if (e.ColumnIndex == Datagridview1.Columns[1].Index)
{
if (e.Value != null)
{
e.Value = DateTime.Parse(e.Value.ToString()).ToUniversalTime();
}
}
LSB71
8-Mar-20 11:56am
View
Hello,
Not much choice alas!
Each value stored in an SQLite database (or manipulated by the database engine) has one of the following storage classes:
NULL. The value is a NULL value.
INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
REAL. The value is a floating point value, stored as an 8-byte IEEE floating point number.
TEXT. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).
BLOB. The value is a blob of data, stored exactly as it was input.
https://www.sqlite.org/datatype3.html
thank you
LSB71
17-Jan-20 11:42am
View
Excuse me, but I don't get the result I want.
The answer from (phil.o) gives me this for example.
Txt_total_P9_cmd.Text = string.Format("{0} €uros H.T.", Math.Round(Val, 2)); = 1254,8
I would like two digits after the decimal point like this (1254.80)
and like this :
Txt_total_P9_cmd.Text = Math.Round(Convert.ToString(Val), 2) + " €uros H.T";
I have the following error (impossible conversion from string to duplicate)
LSB71
19-May-19 2:55am
View
Hello,
Thank you, how should I declare them then?
LSB71
1-Mar-19 1:49am
View
Hello digimanus,
Thank you for your help,
I can not find the solution.
At first I would like to make it easier to understand the meaning.
For example :
(Statut LIKE ? + '%') AND (Email LIKE ? + '%') AND (Date_MES IS NULL OR Date_MES BETWEEN (date1 = Date_fin_MSTPE))";
For simplicity date1 = Date_fin_MSTPE
But I get an error
How to do ?
thank you so much
LSB71
27-Feb-19 15:18pm
View
Can I attach an picture to support my question ?
LSB71
27-Feb-19 12:10pm
View
Thank you very much, I take note of your remarks.
Show More