Форум программистов [Powered by Invision Power Board]

Код

private void addToolStripMenuItem_Click(object sender, EventArgs e)
        {


           //  в конечном итоге передаваемый через  констркутор строка подключения
            string conn = " @Data Source=.\SQLEXPRESS;Atta....... ";
            string query = "SELECT id, login, name, password,role_id FROM users"; 
            SqlDataAdapter da = new SqlDataAdapter(query, conn);
            DataSet tab = new DataSet();
            da.Fill(tab, "users");

            /////////////////////////добавляем новые строки в таблицу
            bd1DataSet ds = new bd1DataSet();
            bd1DataSet.usersDataTable usTablr = ds.users;
            //da.Fill(usTablr);
            bd1DataSet.usersRow rowusers = usTablr.NewusersRow();
            rowusers.id = 2;
            rowusers.login = "grek";
            rowusers.name = "yty";
            rowusers.password = "1";
            rowusers.role_id = 4;
            usTablr.AddusersRow(rowusers);



            classA.InsertRowUsers(query,da,tab);
        }

//метод 
 public void InsertRowUsers(string strquery,SqlDataAdapter da, DataSet tab)
            {
                
                strquery = "INSERT INTO users (id, login, name, password,role_id ) VALUES (?, ?, ?, ?,?)";
                
                command = new SqlCommand(strquery, connection);
                SqlParameterCollection pc = command.Parameters;
                pc.Add("@id", System.Data.SqlDbType.Int, 10, "id");
                pc.Add("@login", System.Data.SqlDbType.NVarChar, 50, "login");
                pc.Add("@name", System.Data.SqlDbType.NVarChar, 50, "name");
                pc.Add("@password", System.Data.SqlDbType.NVarChar, 50, "password");
                pc.Add("@role_id", System.Data.SqlDbType.Int, 10, "role_id");

                da.InsertCommand = command;
               
                da.Update(tab);
               
              
            }