проблема заключаетса в том что немогу сделать обновление даных заполненых с datagridview локальный sql
мой код
с#
dbm dbm = new dbm();
dbm.openconnection();
panel = new SqlConnection(ConfigurationManager.ConnectionStrings["panel"].ConnectionString);
SqlDataAdapter Adapter = new SqlDataAdapter("select * from Tables", panel);
SqlCommandBuilder builder = new SqlCommandBuilder(Adapter);
Adapter.InsertCommand = new SqlCommand("prosed_tables", panel);
Adapter.InsertCommand.CommandType = CommandType.StoredProcedure;
Adapter.InsertCommand.Parameters.Add("@rout", SqlDbType.VarChar, 50 , "rout");
Adapter.InsertCommand.Parameters.Add("@max_place", SqlDbType.Int, 0, "max_place");
Adapter.InsertCommand.Parameters.Add("@empty_place", SqlDbType.Int, 0, "empty_place");
Adapter.InsertCommand.Parameters.Add("@rank_bus", SqlDbType.VarChar, 15, "rank_bus");
Adapter.InsertCommand.Parameters.Add("@sold_token", SqlDbType.Int, 0, "sold_token");
Adapter.InsertCommand.Parameters.Add("@data_rout", SqlDbType.Date, 0, "data_rout");
SqlParameter parameter = Adapter.InsertCommand.Parameters.Add("@id", SqlDbType.Int, 0, "id");
parameter.Direction = ParameterDirection.Output;
sql
CREATE PROCEDURE [dbo].[prosed_tables]
@rout VARCHAR(50),
@max_place INT,
@empty_place INT,
@rank_bus VARCHAR(15),
@sold_token INT,
@data_rout DATE,
@Id INT OUT
AS
INSERT INTO TABLES(rout,max_place,empty_place,rank_bus,sold_token,data_rout)
VALUES (@rout,@max_place,@empty_place,@rank_bus,@sold_token,@data_rout)
SET @Id=SCOPE_IDENTITY()
1 комментарий
Добавить комментарий