Comments by ZaYeD1 - CodeProject

ZaYeD1 24-Feb-22 13:02pm View

no problem with code
only i need code for show percent
about video convert from (avi to Mp4) or other format
i tired search about that no result until now
-_-

ZaYeD1 26-Jan-22 13:28pm View

i use parameter for save sql but
no have idea for use parameter for search

ZaYeD1 11-Dec-21 3:36am View

you are the best

"Just don't insert the StopWork date if it is empty"

now already work
thank you very much

ZaYeD1 9-Dec-21 5:49am View

not work

EnterDate,StartWork,StopWork
it's same date type in database
and i can write full data and leave it empty by access
but with c#
i can write full data but i can't leave any (EnterDate,StartWork,StopWork)
because date type when change to string inside access database will work without any problem
but
order can't arrange column because it read data as string not as date

sorry for write more and sorry for bother you
-_-

ZaYeD1 8-Dec-21 12:41pm View

my code
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = connection;

cmd.CommandText = "insert into Start_Stop_Work (InvoiceNo,ID,ShortName,EnterDate,StartWork,StopWork) values ('" + txtInvoiceNo.Text + "','" + txtID.Text + "','" + txtShortName.Text + "','" + txtEnterToSaudi.Text + "','" + txtStartWorkDate.Text + "','" + txtStopWork.Text + "')";

connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Saved Done for " + txtID.Text);

my code is ok but i got the problem when i try save empty by C# in date type in access database

ZaYeD1 8-Dec-21 12:39pm View

"Required" is set to "No"

it's No
all columns "Required" is set to "No"

i can't leave empty when i insert data (because date type) even when i make type of data number i can't leave textbox empty

only if make it (string type) that let me free and easy to deal with textbox
but can't use order in data grid view

note: the problem only when i try insert data by c#
if i try insert data inside access no problem

when i try change to SQL database it's same problem
the different when i leave textbox empty SQL give me default value 01/01/1900

i want it full empty

ZaYeD1 26-Jan-21 14:30pm View

Insurance_Date_Expired (from dataGridView) not double or int

i try write code
when open form will check one column (Insurance_Data_Expired) each cell for each row
Insurance_Date_Expired - DataTime.Now
if result <= 30 days
MessageBox.Show(result.Tostring() + "Days")

x_x

ZaYeD1 19-Mar-20 20:45pm View

thank you very much :)

ZaYeD1 18-Mar-20 17:27pm View

look again
when i close the program and open it again
i want read first last digit in ID then add +1 for get new ID
example if i do ID 1 , 2 and 3 that mean 3x invoice but if i close program
and i open it again the ID start from 1
and i want start from 4
how i do that???

i do this only

int num = 0;

private void btnID_Click(object sender, EventArgs e)


 StreamWriter sw = new StreamWriter("Data_ID.txt", true);
                string sw_AddID = lblID.Text + ";";
                sw.WriteLine(sw_AddID);
                num++;
                sw.Close();

                lblID.Text = num.ToString();

Comments by ZaYeD1 (Top 9 by date)