C#, Disconnected ADO.Net mode, load from Datable to Sql Table

Vote count:

0

I have two Datables Movies(id, name) and SessionsCinema(id, SessionTime, movie, hall, price). id - is auto increment row.

I work in ado.net Disconnected mode with ms sql database. I want to save settings to sql table. Changes to table "Movies" is ok, but with table "SessionsCinema" there are some errors.

//connection start
            SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
            builder.DataSource = "MYPC\SQLEXPRESS";
            builder.InitialCatalog = "Cinema";
            builder.IntegratedSecurity = true;
            SqlConnection conn = new SqlConnection(builder.ConnectionString);
//connection end


//Movies start
            SqlCommand inscmd = new SqlCommand();
            inscmd.CommandText = "Insert into Movies (name) values(@name); select id = @@IDENTITY from Movies";
            inscmd.Connection = conn;
            inscmd.Parameters.Add("@name", SqlDbType.NVarChar, 250, "name");

            SqlDataAdapter adapter = new SqlDataAdapter(inscmd);
            adapter.InsertCommand = inscmd;
            adapter.Update(Movies);
//Movies end

//SessionsCinema start
            inscmd = new SqlCommand();
            inscmd.CommandText = "Insert into SessionsCinema (SessionTime, movie, hall, price) values(@SessionTime, @movie, @hall, @price); select id = @@IDENTITY from SessionsCinema";
            inscmd.Connection = conn;
            inscmd.Parameters.Add("@SessionTime,@movie,@hall,@price", SqlDbType.NVarChar, 250, "SessionTime,movie,hall,price");
            adapter = new SqlDataAdapter(inscmd);
            adapter.InsertCommand = inscmd;
            adapter.Update(SessionsCinema);
//SessionsCinema end

asked 1 min ago

user2963950

3