Can't Save Data Into Database After Change Data Type from Database RSS

• • Reply
  

  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)

  • Edited by afastars on Dec 23, 2012 01:54 AM
  • Edited by afastars on Dec 23, 2012 01:55 AM
  • Edited by afastars on Dec 23, 2012 01:57 AM
  • Edited by afastars on Dec 23, 2012 01:57 AM
  • Edited by afastars on Dec 23, 2012 04:49 AM
  • Edited by afastars on Dec 23, 2012 04:49 AM
• • Reply
  

  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)

  Programming to simplify, dont look for hard way
  • Edited by afastars on Dec 23, 2012 04:49 AM
  • Edited by oned_gk on Dec 23, 2012 04:49 AM
  • Edited by decker dong - msft on Dec 24, 2012 12:06 AM
  • Edited by decker dong - msft on Dec 24, 2012 12:06 AM
  • Edited by decker dong - msft on Dec 29, 2012 04:22 AM
  • Marked as answer by decker dong - msft on Dec 29, 2012 04:22 AM
• • Reply
  

  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....

  • Edited by afastars on Dec 23, 2012 04:49 AM
  • Edited by afastars on Dec 23, 2012 04:49 AM