Inserting DateTime into Acess Database via C# and Asp.net RSS

• • Reply
  

  anant718

  None

  0 Points

  3 Posts

  Inserting DateTime into Acess Database via C# and Asp.net

  Sep 03, 2011 01:41 AM|anant718|LINK

  This might be a very common and old problem, but still I've struggled with quite a lot and finally I'm posting it here:

  I've to insert DateTime in an Access database, but I'm having trouble doing so. My C# code:

  protected void Button5_Click(object sender, EventArgs e)
      {
          Panel1.Visible = true;
          Panel2.Visible = false;
  
  
          String eventname =
              TextBox6.Text;
          String description = TextBox7.Text;
  
               String coord = TextBox8.Text;
  
               String venue = TextBox9.Text;
  
               String time = TextBox10.Text;
  
               TextBox6.Text = "";
               TextBox7.Text = "";
               TextBox8.Text = "";
               TextBox9.Text = "";
               TextBox10.Text = "";
  
  
          AccessDataSource1.InsertParameters["eventname1"].DefaultValue
              = eventname;
          AccessDataSource1.InsertParameters["description1"].DefaultValue
              = description;
          AccessDataSource1.InsertParameters["coordinator1"].DefaultValue
              = coord;
          AccessDataSource1.InsertParameters["venue1"].DefaultValue
              = venue;
          AccessDataSource1.InsertParameters["time1"].DefaultValue
              = time;
          AccessDataSource1.InsertParameters["time1"].DefaultValue
             = time;
          AccessDataSource1.Insert();
  
          DataList1.EditItemIndex = -1;
          DataList1.DataBind();
      }
  
  And the corresponding Asp.Net script:

  <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
          DataFile="~/events.accdb" SelectCommand="SELECT * FROM [upcoming]"
  
          InsertCommand="INSERT INTO [upcoming] ([eventname], [description],[coordinator], [venue],[time])
           VALUES (@eventname1, @description1,@coordinatior1, @venue1, @time1)" >
  
  
          <InsertParameters>
            <asp:Parameter Name="eventname1" Type="String" />
            <asp:Parameter Name="description1" Type="String" />
            <asp:Parameter Name="coordinator1" Type="String" />
            <asp:Parameter Name="venue1" Type="String" />
            <asp:Parameter Name="time1" Type="DateTime" />
  
          </InsertParameters>
  
      </asp:AccessDataSource>
  <asp:Panel ID="Panel2" runat="server">
     <table>
              <tr><td><asp:Label ID="Label6" runat="server" Text="Name:"></asp:Label></td>
             <td class="style1"> <asp:TextBox ID="TextBox6" runat="server" 
                      Height="24px" Width="548px"></asp:TextBox></td></tr>
  
              <tr><td><asp:Label ID="Label7" runat="server" Text="Description:"></asp:Label></td>
             <td class="style1"> <asp:TextBox ID="TextBox7" runat="server" 
                      Height="155px" TextMode="MultiLine" 
                     Width="555px"></asp:TextBox></td></tr>
  
              <tr><td><asp:Label ID="Label8" runat="server" Text="Event Coordinators:"></asp:Label></td>
             <td class="style1"> 
                 <asp:TextBox ID="TextBox8" runat="server" 
                   Width="548px"></asp:TextBox></td></tr>
  
             <tr><td> <asp:Label ID="Label9" runat="server" Text="Venue:"></asp:Label></td>
              <td class="style1">
                  <asp:TextBox ID="TextBox9" runat="server"  
                   Width="546px"></asp:TextBox></td></tr>
  
              <tr><td><asp:Label ID="Label10" runat="server" Text="Date &Time:"></asp:Label></td>
              <td class="style1">
                  <asp:TextBox ID="TextBox10" runat="server" 
                   Height="23px" Width="543px"></asp:TextBox></td>
                  </tr>
  
             <tr><td> 
                 <asp:Button ID="Button5" runat="server" Text="Insert" 
                     onclick="Button5_Click" /></td>
             <td class="style1"> <asp:Button ID="Button6" runat="server" CommandName="Cancel" 
                     Text="Cancel" onclick="Button6_Click" /></td></tr>
              <table/>
  </asp:Panel>
  
  Please help me in inserting the datetime through the given mechanism.

  datetime asp.net csharp

• • Reply
  

  Decker Dong...

  All-Star

  94110 Points

  18123 Posts

  Re: Inserting DateTime into Acess Database via C# and Asp.net

  Sep 04, 2011 09:42 PM|Decker Dong - MSFT|LINK

  anant718

  AccessDataSource1.InsertParameters["time1"].DefaultValue = time; AccessDataSource1.InsertParameters["time1"].DefaultValue = time;

  Hello,

  First I saw that you've duplicated your statements, plz remove one of them.

  Second, Please make sure that your "time" must be converted to DateTime successfully, and you can do inserting successfully as well.

  PS: What's the problem you've got?

• • Reply
  

  ANILBABU

  Member

  60 Points

  446 Posts

  Re: Inserting DateTime into Acess Database via C# and Asp.net

  Jun 13, 2013 11:09 AM|ANILBABU|LINK

  I am inserting textbox date value into database using asp.net

  Database column datatype is date

  This is my code ,

  I am getting an error like this:::

  String was not recognized as a valid DateTime

  What is the error in my code???

  please help me

  SqlParameter validUntil = new SqlParameter("@ValidUntil", SqlDbType.Date);
  //validUntil.Value = TextBox2.Text.ToString();
  validUntil.Value = Convert.ToDateTime(TextBox2.Text);

  cmd.Parameters.Add(validUntil);