daImport.InsertCommand = new SqlCommand("insert into import (warehouse, code, discription, izmer, cizmer, price, balance) values (@warehouse, @code, @discription, @izmer, @cizmer, @price, @balance)", sqlconn);
            daImport.InsertCommand.Parameters.Add("@warehouse", SqlDbType.Int, 0, "warehouse");
            daImport.InsertCommand.Parameters.Add("@code", SqlDbType.BigInt, 0, "code");
            daImport.InsertCommand.Parameters.Add("@discription", SqlDbType.NVarChar, 100, "discription");
            daImport.InsertCommand.Parameters.Add("@izmer", SqlDbType.NVarChar, 20, "izmer");
            daImport.InsertCommand.Parameters.Add("@cizmer", SqlDbType.Int, 0, "cizmer");
            daImport.InsertCommand.Parameters.Add("@price", SqlDbType.Decimal, 0, "price");
            daImport.InsertCommand.Parameters.Add("@balance", SqlDbType.Decimal, 0, "balance");
            string queryUpdateImport = "update import " +
                                       "set warehouse = @warehouse, code = @code, discription = @discription, izmer = @izmer, cizmer = @cizmer, price = @price, balance = @balance " +
                                       "where id = @id";
            daImport.UpdateCommand = new SqlCommand(queryUpdateImport, sqlconn);
            SqlParameter[] sqlParCollect = new SqlParameter[daImport.InsertCommand.Parameters.Count];
            daImport.InsertCommand.Parameters.CopyTo(sqlParCollect, 0);
            daImport.UpdateCommand.Parameters.AddRange(sqlParCollect);
            daImport.UpdateCommand.Parameters.Add("@id", SqlDbType.Int, 0, "id");
            daImport.TableMappings.Add("Table", "import");