now()function cant be used. im reading 2 variable dates from datepickers....
iv allready solved aneway,, i created a function to read the date as string, break it in to charecters and then re-arrenge it the way i want
i have this error.. when i save the value of datetimepicker to sql database it will just save like this 0000-00-00.. and im having error when i select the value in the database cause its null. can you guys help me with my prob?
here's my code
Dim strinsertMember As String
If txtFname.Text = "" Or txtLname.Text = "" Or txtAge.Text = "" Or txtAddress.Text = "" Or txtPhone.Text = "" Or cboMinistry.Text = "" Then
MsgBox("Required fields are empty", MsgBoxStyle.Exclamation)
strinsertMember = "INSERT INTO tbl_members" & "(Fname,Lname,Age,Birthday,Address,Phone,Ministry)" & " VALUES('" & txtFname.Text.ToUpper & "','" & txtLname.Text.ToUpper & "','" & txtAge.Text.ToUpper & "','" & Format$(DateTimePicker1.Value.ToString, "YYYY-mm-dd") & "','" & txtAddress.Text & " ','" & txtPhone.Text & "','" & cboMinistry.Text & "')"
CLSCONN = New DBConnect
MsgBox("Data has been save", MsgBoxStyle.Information)
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...