i can't save my data into database after i change the date data type into
datatime, but if i use
the original data type which is varchar(20) i can save it without any probelm, i need to use datetime data type. need help
below is my sample code:
Dim mySQLConnection = New SqlConnection()
mySQLConnection.ConnectionString = ConfigurationManager.ConnectionStrings("Default").ConnectionString
Try
mySQLConnection.Open()
Dim cmd As New SqlCommand()
cmd.Connection = mySQLConnection
cmd.CommandText = "select * from MaklumatPelajar where NoIc=@NoIc"
cmd.Parameters.AddWithValue("NoIc", txtNokp.Text)
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable()
da.Fill(dt)
If dt.Rows.Count > 0 Then
ClientScript.RegisterStartupScript(Page.[GetType](), "validation", "<script language='javascript'>alert('No Kad Pengenalan Telah Wujud')</script>")
Else
cmd.CommandText = "INSERT INTO MaklumatPelajar" & _
"(Nama,NoIc,Date)" & _
"VALUES(@Nama,@NoIc,@Date")
'Maklumat Pelajar
cmd.Parameters.AddWithValue("Nama", txtnama.Text)
'cmd.Parameters.AddWithValue("NoIc", txtNokp.Text)
cmd.Parameters.AddWithValue("Date", Date.Text)
afastars
Member
52 Points
221 Posts
Can't Save Data Into Database After Change Data Type from Database
Dec 23, 2012 01:53 AM|LINK
hi all expertise i got problem now
i can't save my data into database after i change the date data type into datatime, but if i use
the original data type which is varchar(20) i can save it without any probelm, i need to use datetime data type. need help
below is my sample code:
Dim mySQLConnection = New SqlConnection() mySQLConnection.ConnectionString = ConfigurationManager.ConnectionStrings("Default").ConnectionString Try mySQLConnection.Open() Dim cmd As New SqlCommand() cmd.Connection = mySQLConnection cmd.CommandText = "select * from MaklumatPelajar where NoIc=@NoIc" cmd.Parameters.AddWithValue("NoIc", txtNokp.Text) Dim da As New SqlDataAdapter(cmd) Dim dt As New DataTable() da.Fill(dt) If dt.Rows.Count > 0 Then ClientScript.RegisterStartupScript(Page.[GetType](), "validation", "<script language='javascript'>alert('No Kad Pengenalan Telah Wujud')</script>") Else cmd.CommandText = "INSERT INTO MaklumatPelajar" & _ "(Nama,NoIc,Date)" & _ "VALUES(@Nama,@NoIc,@Date") 'Maklumat Pelajar cmd.Parameters.AddWithValue("Nama", txtnama.Text) 'cmd.Parameters.AddWithValue("NoIc", txtNokp.Text) cmd.Parameters.AddWithValue("Date", Date.Text)oned_gk
All-Star
31519 Points
6435 Posts
Re: Can't Save Data Into Database After Change Data Type from Database
Dec 23, 2012 02:12 AM|LINK
try
Dim dtime As DateTime = DateTextbox.Text . . . cmd.Parameters.AddWithValue("Date", dtime)afastars
Member
52 Points
221 Posts
Re: Can't Save Data Into Database After Change Data Type from Database
Dec 23, 2012 04:49 AM|LINK
hi oned_gk
i got it, you resolve my problem....