| Код |
string zapr;
zapr="INSERT INTO [kirpich].[dbo].[T_DO] "+
" ([dateF]" +
" ,[id_f1]"+
" ,[id_f2]" +
" ,[id_f3]"+
" ,[id_f4]"+
" ,[intF1]"+
" ,[intF2]"+
" ,[floatF3]"+
" ,[floatF4]"+
" ,[floatF5]"+
" ,[floatF6]"+
" ,[floatF7]"+
" ,[floatF8]"+
" ,[floatF9]"+
" ,[floatF10]) " +
" VALUES "+
"('" + Calendar1.SelectedDate.ToShortDateString() +"'" +
"," + DropDownList1.Text + ""+
"," + DropDownList2.Text + "" +
"," + DropDownList3.Text + "" +
"," + DropDownList4.Text + "" +
"," + Convert.ToInt32(Textbox1.Text)+""+
"," + Convert.ToInt32(Textbox2.Text)+ "" +
"," + Convert.ToDouble(Textbox3.Text) + "" +
"," + Convert.ToDouble(Textbox4.Text) + "" +
"," + Convert.ToDouble(Textbox5.Text) + "" +
"," + Convert.ToDouble(Textbox6.Text) + "" +
"," + Convert.ToDouble(Textbox7.Text) + "" +
"," + Convert.ToDouble(Textbox8.Text) + "" +
"," + Convert.ToDouble(Textbox9.Text) + "" +
"," + Convert.ToDouble(Textbox10.Text) +") GO ";
Configuration gif = WebConfigurationManager.OpenWebConfiguration("/");
ConSTR con = new ConSTR(config.ConnectionStrings.ConnectionStrings["STRINGCON"].ConnectionString);
SqlConnection sqls = new SqlConnection(con);
try
{
SqlDataAdapter da = new SqlDataAdapter(zapr, con);
SqlCommand command = new SqlCommand(zapr,sqls);
DataSet sets = new DataSet();
da.Fill(sets, "[T_DO]");
sqls.Open();
}
catch (Exception e)
{
MessageBox.Show(e.Message.ToString());
}
finally
{
sqls.Close();
}
|
выпадает ошибка не могу найти ошибки
//System.FormatException: Входная строка имела неверный формат.
"INSERT INTO [kirpich].[dbo].[T_DO] "+ // жалуется на эту строку |
)