Comments by asasql - CodeProject

asasql 27-Jun-15 1:27am View

how do i use this code in VB.NET language?

asasql 11-Jun-15 6:25am View

i tried to insert a formula like this:
ToText({siswa.Tanggal_Lahir}, "MMM dd, yyyy")

but a error message said "too many arguments" showed up

asasql 9-Jun-15 20:23pm View

just one table, but i want all the row in the table to be viewed in crystal report.

asasql 24-May-15 7:34am View

Deleted

thank you. all the column finally adjusting to the size of datagridview.
the only problem left is that in the column date of birth in excel the time is also displayed like this: (12/5/1994 12:00 am).
how do i get rid of the time display using coding?

asasql 23-May-15 3:06am View

how do i bind the data to datasource?

asasql 1-May-15 10:09am View

what proper parameterised queries that i should use on my sql command?

asasql 1-May-15 10:08am View

still not working. i add CInt CDate for integer type data and date but "invalidcastexception was unhandled" still showed up with the same error.

asasql 29-Apr-15 6:46am View

how do i do that?

asasql 29-Apr-15 3:48am View

i put _cn.open before cmd.ExecuteNonQuery(), now the error said "The ConnectionString property has not been initialized" on tne _cn.open().

asasql 28-Apr-15 11:22am View

there is an error with cmd.ExecuteNonQuery(), "invalidOperationException was unhandled" showed up when i clicked button1 to update datagridview.
the error description said "ExecuteNonQuery requires an open and available Connection. The connection's current state is closed".

asasql 1-Apr-15 0:31am View

thanks.i'll try that.
after creating the scrollbar in design form how do i make it work?

asasql 30-Mar-15 11:21am View

still not working.
whre should i put the:
Dim I as integer=sql.ExecuteNonQuery()
Msgbox(I)
in class or form coding?

asasql 29-Mar-15 9:56am View

where should i put the coding?
is it in class or the form ?

asasql 28-Mar-15 3:46am View

thank you very much, that was my mistake.the program is running, But after i input all the data and click the button save the message box that says "data berhasil di simpan" is displayed, But the data that was saved wasn't displayed on the datagridview or the sql server.

asasql 28-Mar-15 3:26am View

i did it. but i can't change the date in date time picker after i select the date, Also now there is another error, When click the button save,there is an error in class student "sql exception was unhandled" how do i solve this?

i'm sorry that i forgot to ask about the button save and post the sql query i used in sql server 2012 before.

sql script:
Create Database KPIRWAN
use KPIRWAN

Create Table siswa
(
Nis int primary key,
Nisn int,
Nama_Siswa varchar(40),
Jenis_Kelamin varchar (10),
Kota_Lahir varchar (10),
Tanggal_Lahir date,
Agama varchar (10),
Berat_Badan int,
Tinggi_Badan int)

select*from siswa
drop table siswa
Drop database KPIRWAN

Comments by asasql (Top 15 by date)