Click here to Skip to main content
16,018,949 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
for insert a record into table error will occured "Error converting data type nvarchar to datetime."
this is my code

SqlConnection con = new SqlConnection(cn.ConnectionStrings);
SqlCommand cmd1 = new SqlCommand();
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@ButtonFlag", "Save");
cmd1.Parameters.AddWithValue("@OwnId", txtOwner.Text.Trim());
cmd1.Parameters.AddWithValue("@ProductName", txtProdNm.Text.Trim());
cmd1.Parameters.AddWithValue("@PGroId", ddlProdGroup.SelectedItem.Value);
cmd1.Parameters.AddWithValue("@Manufacture", txtManufacture.Text.Trim());
cmd1.Parameters.AddWithValue("@Website", txtWebsite.Text.Trim());
cmd1.Parameters.AddWithValue("@LastPrice", txtLastPrice.Text.Trim());
cmd1.Parameters.AddWithValue("@UnitPrice", txtUnitPrice.Text.Trim());
cmd1.Parameters.AddWithValue("@Unit",ddlUnit.SelectedItem.Text);
cmd1.Parameters.AddWithValue("@Description", txtDesc.Text.Trim());
cmd1.Parameters.AddWithValue("@ActualCost", txtActCost.Text.Trim());
cmd1.Parameters.AddWithValue("@ManufactureDate",txtManufacture.Text);
cmd1.Parameters.AddWithValue("@ExpiryDate",txtExpiryDate.Text);
cmd1.Parameters.AddWithValue("@SupportExipryDate",txtSuppExpiryDate.Text);
cmd1.Parameters.AddWithValue("@Date",txtDate.Text);
cmd1.Parameters.AddWithValue("@TaxRate", txtTaxRate.Text.Trim());
cmd1.Parameters.AddWithValue("@Stock",txtStock.Text.Trim());
cmd1.Parameters.AddWithValue("@VenId", txtVendor.Text.Trim());
cmd1.CommandText = "[dbo].[ProductProcedure]";
cmd1.Connection = con;
con.Open();
SqlDataAdapter adp = new SqlDataAdapter(cmd1);
DataTable dt = new DataTable();
adp.Fill(dt);
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert User", "alert('Record Save Successfully..!!')", true);
con.Close();
Posted

1 solution

Onyour DataBase You Define date values as date like,

Manufacture nvarchar(max),
ExpiryDate date,

In Your C# You Passing, Text Values of Dates like
cmd1.Parameters.AddWithValue("@ExpiryDate",txtExpiryDate.Text);

So only, The Error converting varchar to datetime

Understand how to pass the date value in c#,
Gothrough,Culture Info

DateTime now1 = DateTime.Today;
cmd1.Parameters.AddWithValue("@Date", now1.ToShortDateString());
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900