SqlException: Conversion failed when converting date and/or time from character string

akhter

SOLVED CLOSED ACTIVE ANSWERED
User: akhter
Posted: on Jul 24, 2019 02:33 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 1795

when i am inserting date into data base it giving error of

Conversion failed when converting date and/or time from character string

my approach for inserting data into table from gridview

      protected void gvso_RowCommand(object sender, GridViewCommandEventArgs e)
      {          
          if (e.CommandName.Equals("Insert"))
          {
              TextBox txtaddorderref = (TextBox)gvso.FooterRow.FindControl("txtaddorderref");
              DropDownList ddlCusName = (DropDownList)gvso.FooterRow.FindControl("ddladdCustomerName");
              TextBox txtpirority = (TextBox)gvso.FooterRow.FindControl("txtaddSOpirority");
              TextBox ddlstatus = (TextBox)gvso.FooterRow.FindControl("txtstatusf");
              ddlstatus.Text = "Open";
              TextBox date = (TextBox)gvso.FooterRow.FindControl("txtaddOrder_date") ;
              // DateTime date1 = Convert.ToDateTime(date.Text);
 
              con = new SqlConnection("Data Source=ATLANTIC\\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=SilverProduction;MultipleActiveResultSets=True;");
 
              con.Open();
              SqlCommand ocmd = new SqlCommand();
              ocmd.CommandText = "INSERT INTO SalesOrder VALUES ('" + txtaddorderref.Text + "'," + ddlCusName.SelectedValue + ",'" + txtpirority.Text + "','" + ddlstatus.Text + "','" + date.Text + "','" + txtempid.Text + "')";
              
              ocmd.Connection = con;
              ocmd.ExecuteNonQuery();
              BindGrid(searchono.Text.Trim());
 
              con.Close();
          }
      }

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 11

Reply
ANSWER
User: pandeyism
Replied: on Jul 24, 2019 08:24 AM
Report

Hi akhter,

Check below code it's working.

HTML

Date :
<asp:TextBox runat="server" ID="txtDate" />
<br />
<asp:Button Text="Insert" runat="server" OnClick="Save" />
<br />
<asp:GridView runat="server" ID="gvDates" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="DateData" HeaderText="DateData" />
    </Columns>
</asp:GridView>

Namespaces

using System.Data.SqlClient;
using System.Data;
using System.Configuration;

Code

protected void Save(object sender, EventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand("INSERT INTO InsertDate VALUES(@Date)", con);
    cmd.Parameters.AddWithValue("@Date", txtDate.Text);
    con.Open();
    cmd.ExecuteNonQuery();
    con.Close();
    cmd = new SqlCommand("SELECT DateData FROM InsertDate", con);
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill(dt);
    gvDates.DataSource = dt;
    gvDates.DataBind();
}

Screenshot

Database

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

SqlException: Conversion failed when converting date and/or time from character string

Conversion failed when converting date and/or time from character string

Company

Explore

Follow us

Contact Us