Click here to Skip to main content
15,886,258 members

Comments by Ernest Jan Sandoval (Top 8 by date)

Ernest Jan Sandoval 16-Mar-22 10:30am View    
and how can i put it in datagridview in different rows?
Ernest Jan Sandoval 16-Mar-22 10:29am View    
thank you .i did not notice it
Ernest Jan Sandoval 2-Mar-22 19:19pm View    
sorry im going to show it to my teacher later and im afraid of changing it because maybe some codes that i write already may affect it.but dont worry i will study more and i will apply what you taught
Ernest Jan Sandoval 2-Mar-22 10:23am View    
CREATE TABLE "Client" (
"ID" INTEGER NOT NULL UNIQUE,
"fName" TEXT NOT NULL,
"lName" TEXT NOT NULL,
"address" TEXT NOT NULL,
"contact" INTEGER NOT NULL,
"age" INTEGER NOT NULL,
"gender" TEXT NOT NULL,
PRIMARY KEY("ID" AUTOINCREMENT)
)
Ernest Jan Sandoval 2-Mar-22 10:22am View    
string txtQuery = "INSERT INTO Client (ID,fName,lName,address,contact,age,gender) Values('" + txtID.Text + "','" + txtFname.Text + "', '" + txtLname.Text + "','" + txtAddress.Text + "','" + txtContact.Text + "','" + dtpClient.Value.ToShortDateString() + "','" + cbGender.Text+"')"; i change the age to dateTimePicker.still data type mismatch