Формирование Delete и Update запроса для tableAdapter

         private void SqlInsertCommand() {
            _sqlConnection.Open();
            for (int i = 0; i < _mainDataSet.Tables.Count; i++) {
                string cmd = "insert into [" + _mainDataSet.Tables[i].TableName + "] values (";
                for (int j = 0; j < _mainDataSet.Tables[i].Columns.Count; j++)
                    cmd += "@" + _mainDataSet.Tables[i].Columns[j].ColumnName + ", ";
                cmd = cmd.Substring(0, cmd.Length - 2) + ")";
                _allAdapters[i].InsertCommand = new SqlCommand(cmd, _sqlConnection);
                SqlParameterCollection pc = _allAdapters[i].InsertCommand.Parameters;
                for (int j = 0; j < _mainDataSet.Tables[i].Columns.Count; j++)
                    pc.Add("@" + _mainDataSet.Tables[i].Columns[j].ColumnName,
                                parameterType(_mainDataSet.Tables[i].Columns[j].DataType.ToString()), 0,
                                _mainDataSet.Tables[i].Columns[j].ColumnName);
            }
            _sqlConnection.Close();
        }

            allAdapters.Add(new SqlDataAdapter(@"Select * From " + tableName, conn));
            SqlCommandBuilder builder = new SqlCommandBuilder(allAdapters[allAdapters.Count - 1]);
            allAdapters[allAdapters.Count - 1].InsertCommand = builder.GetInsertCommand();
            allAdapters[allAdapters.Count - 1].DeleteCommand = builder.GetDeleteCommand();
            allAdapters[allAdapters.Count - 1].UpdateCommand = builder.GetUpdateCommand();

builder.GetInsertCommand();